SQL & Python Practice by Topic

ROW_NUMBER, RANK, LAG, LEAD, running totals, moving averages

INNER, LEFT, RIGHT, CROSS, self-joins, multi-table joins

GROUP BY, HAVING, COUNT, SUM, AVG, conditional aggregation

Correlated subqueries, EXISTS, IN, Common Table Expressions

SELECT, WHERE, ORDER BY, LIMIT, LIKE, BETWEEN, NULL handling

DATE functions, strftime, JULIANDAY, date arithmetic, time-series

COALESCE, NULLIF, CASE WHEN, type casting, deduplication

UNION, UNION ALL, INTERSECT, EXCEPT — combining result sets

groupby, agg, transform, named aggregation, pivot tables

merge, join, concat, multi-key matching, merge indicators

Boolean indexing, loc, iloc, query, isin, conditional selection

rolling, expanding, shift, diff, rank, cumulative operations

DataFrame creation, selection, sorting, renaming, type conversion

to_datetime, dt accessor, resample, period, timedelta

pivot_table, melt, stack, unstack, wide-to-long transforms