SELECT LOCATION FROM cinema WHERE capacity  >  300 GROUP BY LOCATION HAVING count(*)  >  1
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
select location from cinema where capacity > value group by location having count ( * ) > value
Find the locations that have more than one movie theater with capacity above 300 .