Show different locations and the number of performances at each location.
select location, count(*) from performance group by location
Which is the least common location?
select location from performance group by location order by count(*) asc limit 1
How about the most common one?
select location from performance group by location order by count(*) desc limit 1