Show all locations for the cinemas.
select location from cinema
Only show locations of cinemas with a capacity above 300.
select location from cinema where capacity > 300
How about locations with more than one such cinema?
select location from cinema where capacity > 300 group by location having count(*) > 1