Find the locations that have more than one movie theater with capacity above 300.
SELECT LOCATION FROM cinema WHERE capacity  >  300 GROUP BY LOCATION HAVING count(*)  >  1
locations with more than one movie theater refers to HAVING COUNT(*) > 1; movie theater with capacity above 300 refers to capacity > 300;