Show all locations of cinemas.
select location from cinema
What are locations for the cinemas with a capacity above 300?
select location from cinema where capacity > 300
What are locations with at least two such cinemas?
select location from cinema where capacity > 300 group by location having count(*) >= 2