Mostre todos os locais com pelo menos dois cinemas com capacidade superior a 300.
CREATE TABLE cinema (LOCATION VARCHAR, capacity INTEGER)
SELECT LOCATION FROM cinema WHERE capacity > 300 GROUP BY LOCATION HAVING COUNT(*) >= 2