SELECT LOCATION FROM performance GROUP BY LOCATION HAVING COUNT(*)  >=  2
Show the locations that have at least two performances.
SELECT LOCATION FROM performance GROUP BY LOCATION HAVING COUNT ( * ) > = 2
select location from performance group by location having count ( * ) > = value
Show the locations that have at least two performances .