// query anatomy — revision sheet

One query. Every clause. Every side-topic.

Click any part of the query for its explanation, syntax, and variants — including the parts that don't normally fit in a SELECT (indexing, transactions, stored procedures, correlated subqueries). Flip the toggle to see written order vs. actual execution order.