GROUP BY

Understand

Your manager has a table with one row per order and wants one row per region. Not a filter, not a sort. Fewer rows come out than went in, with the amounts added up inside each one. That collapsing is what GROUP BY does, and it is the first thing in SQL with no spreadsheet equivalent you already know.

SELECT what_identifies_the_group, what_to_work_out
FROM where_it_lives
GROUP BY the_same_thing_again;