SQL Power Queries

Split your data into groups and run aggregates on each — like pivot tables in SQL.

Complete Aggregate Functions to unlock

Filter groups after aggregation — WHERE's smarter sibling.

Complete GROUP BY to unlock

Combine data from two tables by matching on a shared column.

Complete HAVING to unlock

Include all rows from the left table, even when there's no match on the right.

Complete INNER JOIN to unlock

Chain three or more tables together to traverse the full data model.

Complete LEFT JOIN to unlock

Add if/else logic directly inside your SQL query.

Complete Multiple JOINs to unlock

Manipulate and transform text data with SQL's built-in string toolkit.

Complete CASE Expressions to unlock

Work with timestamps, extract date parts, and calculate time intervals.

Complete String Functions to unlock

Nest a query inside another — let the inner query's result drive the outer one.

Complete Date & Time to unlock

Treat a subquery's result as if it were its own table, and query it further.

Complete Subqueries to unlock

Join a table to itself to compare rows within the same table — like employees to their managers.

Complete Subqueries in FROM (Derived Tables) to unlock

Keep every row from both tables, matched where possible, NULL where not.

Complete Self Joins to unlock

Combine, find common rows between, or subtract one query's results from another.

Complete FULL OUTER JOIN to unlock

Make sure missing data doesn't silently break your sums, averages, and counts.

Complete Set Operations: UNION, INTERSECT, EXCEPT to unlock