SELECT count(*) ,  LOCATION FROM shop GROUP BY LOCATION
Find the number of shops in each location.
SELECT count ( * ) , LOCATION FROM shop GROUP BY LOCATION
select count ( * ) , location from shop group by location
Find the number of shops in each location .