Order of operations

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