Which locations have 2 or more cinemas with capacity over 300?
SELECT LOCATION FROM cinema WHERE capacity  >  300 GROUP BY LOCATION HAVING count(*)  >=  2
locations with 2 or more cinemas = HAVING COUNT(*) >= 2; capacity over 300 refers to capacity > 300;