i've got a database with 12 tables, with about 1200 items in each table.
there are about 300 distinct "areas" in the database.

i can get a list of these distinct areas using the distinct keyword.

how can i get a list of the number of times each of these distinct areas are listed without querying each distinct area?