Show all the locations with at least two cinemas with capacity above 300.
SELECT LOCATION FROM cinema WHERE capacity  >  300 GROUP BY LOCATION HAVING count(*)  >=  2
locations with at least two cinemas = HAVING COUNT(*) >= 2; capacity above 300 = capacity > 300;