Show the title for films.
select title from film
Show the name for cinemas.
select name from cinema
Show all the schedule record.
select * from schedule
How about the date and the price for each of those records along with the film title and cinema name.
select t3.name, t2.title, t1.date, t1.price from schedule as t1 join film as t2 on t1.film_id = t2.film_id join cinema as t3 on t1.cinema_id = t3.cinema_id