CREATE TABLE schedule (cinema_id NUMBER, film_id NUMBER, date CLOB, show_times_per_day NUMBER, price NUMBER)
CREATE TABLE film (film_id NUMBER, rank_in_series NUMBER, number_in_season NUMBER, title CLOB, directed_by CLOB, original_air_date CLOB, production_code CLOB)
CREATE TABLE cinema (cinema_id NUMBER, name CLOB, openning_year NUMBER, capacity NUMBER, location CLOB)

Give me the title and highest price for 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"