Database: cinema
Question: In which locations are there more than one movie theater with capacity above 300?
SQL:
SELECT LOCATION FROM cinema WHERE capacity  >  300 GROUP BY LOCATION HAVING count(*)  >  1