What are the title and maximum price of each film?
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
title of each film refers to T2.title; maximum price of each film refers to MAX(T1.price);