Copy Query and Syntax:

Query: Provide Group Count based on Location of Sales Table
Syntax: Select Location, count(*) as Number from Sales group by Location