Oracle SQL Code Only

11 -- == -- -- Write a query to output the details of single film performance onput in -- Task 1 part 2. -- The details needed are the film name, and the cinema, screen, and date and -- time it is being shown. -- -- The headings and details should be meaningful to any reader of the report. -- I.e. -- -- Film Title Cinema Screen Date Time -- ------------------------------------- ------------------------------------- ------ ----------------- ----- -- Modern Times Grange Cinema 2 Wed 01-Sep-2021 08:15 -- -- Hint: -- -- Type your query below: -- == -- -- Write a query to output the details of the three night showing you entered as shown -- below. -- -- Showin Film Title Cinema Screen First Night Last Night -- ------ --------------------- --------------- ------ -------------- --------------- -- 183557 Knives Out Grange Cinema 3 Fri August 6 Sun August 8 -- -- Hint: -- -- Type your query below:

-- END OF ASSIGNMENT TASK TWO ---------------------------------------------------

Cinema Screen Contains > PK KPKFK Cinema Cinema_Name Location Year_Opened HH PK Screen Capacity FK Manager Employs Presents Manages V Staff Showing Showing_No PK - FK Cinema FK Screen PK Employee_No Name Address Phone_No DOB Date_Joined FK Film_No Supervises V A Salary FK Supervisor shown at Part of FK Cinema Performance PKFK Showing No Film PK Performance_Date PK Film_No Performance_Time Takings Film_Name Classification Duration Attendees Description Year_Released