How many movie theatres have a capacity of at least 300 people?
select count ( * ) from cinema where capacity > = 300
What are their names?
select name from cinema where capacity > = 300
What are their specific locations?
select location from cinema where capacity > = 300
Which theatre has the largest capacity?
select * from cinema order by capacity desc limit 1
Which year was Codling open?
select openning_year from cinema where name = "Codling"