The order you write a SQL query and the order the database executes it are completely different — and that gap explains most SQL mistakes.

Notes and highlights from reading SQL Performance Explained by Markus Winand.