CREATE TABLE schedule (price NUMBER, film_id VARCHAR2)
CREATE TABLE film (title VARCHAR2, film_id VARCHAR2)

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
SELECT "T2"."title", MAX("T1"."price") FROM "schedule" "T1" JOIN "film" "T2" ON "T1"."film_id" = "T2"."film_id" GROUP BY "T1"."film_id"