What are the locations of the performances?
select location from performance
Show me the number of performances at each location.
select count(*) from performance group by location
Which locations have at least two performances?
select location from performance group by location having count(*) >= 2