SELECT LOCATION ,  COUNT(*) FROM performance GROUP BY LOCATION
Show different locations and the number of performances at each location.
SELECT LOCATION , COUNT ( * ) FROM performance GROUP BY LOCATION
select location , count ( * ) from performance group by location
Show different locations and the number of performances at each location .