Show the title for each film.
select title from film
Also show the prices for each of them.
select t2.title, t1.price from schedule as t1 join film as t2 on t1.film_id = t2.film_id
What is the maximum price for each?
select t2.title, max(t1.price) from schedule as t1 join film as t2 on t1.film_id = t2.film_id group by t1.film_id