SQL queries read data with SELECT … FROM … WHERE … ORDER BY.
1Points
Logical order: FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY → LIMIT
Compare with NULL using IS NULL / IS NOT NULL
LIKE: % any sequence, _ one character
COUNT(*) counts rows; COUNT(col) skips NULLs; aggregates ignore NULLs