SELECT fundamentals

Projection, filters, sorting, and LIMIT/OFFSET.

SQL is a language for describing the result you want, not the steps to get it. Start with FROM, filter with WHERE, then decide which columns to show.

SELECT name, email
FROM person
WHERE active = TRUE
ORDER BY name
LIMIT 50;