FROM & JOINs determine & filter rows
WHERE more filters on the rowsGROUP BY combines those rows into groups
HAVING filters groups
ORDER BY arranges the remaining rows/groups
LIMIT filters on the remaining rows/groups
FROM & JOINs determine & filter rows
WHERE more filters on the rows