Show the names for all cinemas.
select name from cinema
Also show the showtimes per day for those cinemas.
select t2.name, t1.show_times_per_day from schedule as t1 join cinema as t2 on t1.cinema_id = t2.cinema_id
For each cinema, also show the total number of showtimes per day.
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