SELECT count(*) ,  LOCATION FROM shop GROUP BY LOCATION
How many shops are there in each location?
SELECT count ( * ) , LOCATION FROM shop GROUP BY LOCATION
select count ( * ) , location from shop group by location
How many shops are there in each location ?