Cheatsheets

SQL Cheat Sheet — Queries & JOINs

Queries

SQL
SELECT * FROM users WHERE age >= 18 ORDER BY name LIMIT 50;

JOINs

SQL
SELECT u.name, o.total
FROM users u
INNER JOIN orders o ON u.id = o.user_id;

Aggregates

SQL
SELECT category, COUNT(*) FROM products GROUP BY category;