what is the total number of showtimes at each cinema?
select t2.name, sum ( t1.show_times_per_day ) from schedule as t1 join cinema as t2 on t1.cinema_id = t2.cinema_id group by t1.cinema_id
what cinema has the most showings in one day?
select t2.name from schedule as t1 join cinema as t2 on t1.cinema_id = t2.cinema_id group by t1.cinema_id order by sum ( t1.show_times_per_day ) desc limit 1
What cinema has the highest capacity?
select name from cinema order by capacity desc limit 1
what cinema is in Cork county?
select name from cinema where location = "County Cork"