ORDER BY & Dates

ORDER BY sorts the final result. Ascending (A→Z, smallest first) is the default; add DESC for descending:

SELECT state, num_accidents FROM accident_counts ORDER BY num_accidents DESC;

Sort by several columns by listing them — ORDER BY state, num_accidents DESC sorts by state, then by accidents within each state.

Without ORDER BY, a database may return rows in any order at all.