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)
CREATE TABLE schedule (cinema_id NUMBER, film_id NUMBER, date CLOB, show_times_per_day NUMBER, price NUMBER)

Show cinema name, film title, date, and price for each record in schedule.
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
SELECT "T3"."name", "T2"."title", "T1"."date", "T1"."price" FROM "schedule" "T1" JOIN "film" "T2" ON "T1"."film_id" = "T2"."film_id" JOIN "cinema" "T3" ON "T1"."cinema_id" = "T3"."cinema_id"