Show the locations that have at least two performances.
SELECT LOCATION FROM performance GROUP BY LOCATION HAVING COUNT(*)  >=  2
locations that have at least two performances refers to HAVING COUNT(*) >= 2;