SQL Query Basics

SELECT, WHERE, JOINs and aggregation — the core SQL every interview expects you to know cold.