Show different locations and the number of performances at each location.
create table performance (location varchar, PRIMARY KEY (location))
select location, count(*) from performance group by location