-- QUESTION 7

-- ==========

--

-- Which were the showings with the most performances? In which cinema were,

-- they shown, on which screen and how many performances were there starting

-- on which date. Format the output as given below:

--

-- Hint: Reserach the formatting operators fm and th

--

-- Solution Test:

--

-- Cinema Screen Performances Started on

-- -------------------------------------------------- ---------- ------------ -------------------------------------------------------------------------------

-- Marvale Rex 1 9 Friday, September 3rd

-- Treban Picturehouse 2 9 Monday, August 9th

-- Treban Picturehouse 1 9 Monday, September 20th

-- Odeon on the Hill 2 9 Sunday, August 15th

--

-- Type your query below:

-- QUESTION 8

-- ==========

--

-- Produce a report for all showings of "Casablanca", providing the film name,

-- in which cinema each showing took place and the takings per seat available

-- and takings per person attending.

--

-- Hint: Use the total takings and the total capacity to determine the average

-- not the AVG function. Use formatting to limit the decimal places to 2.

--

-- Solution Test:

-- FILM_NAME CINEMA Takings per seat Takings per person

-- ---------- -------------------------------------------------- ---------------- ------------------

-- Casablanca Marvale Rex 9.62 12.81

-- Casablanca The Glory Showhouse 12.14 12.67

-- Casablanca Treban Picturehouse 10.87 13.31

-- Casablanca Grange Cinema 15.02 19.25

--

-- Type your query below:

-- QUESTION 9

-- ==========

--

-- Write a query to list the cinema names of all cinemas which employ more than 12 employees.

--

-- Solution Test:

--

-- CINEMA_NAME Number of Staff

-- --------------------------------------------- ---------------

-- Grange Cinema 20

-- Masterton Multiplex 27

-- The Glory Showhouse 15

--

-- Type your query below:

-- QUESTION 10, 11, 12

-- ===================

-- Write three queries to provide information about YOU and YOUR orders from

-- Task 1

--

-- 10

-- ==

--

-- Create a single line report containing YOUR details as entered on the database

-- in the following format:

--

-- Fullname Address Employed for

-- ------------------------------- --------------------------------------------------------- ---------------------------

-- Leon Marvin The Marches, Teal Avenue, Lindon 9y 10m

-- Fullname Address Employed for

--

-- Where 9y 10m indicates you has been employed for 9 complete years

-- plus 10 complete months at the time the query is run

--

-- Hint:

--

-- https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions002.htm#SQLRF51178

--

-- Type your query below:

--

-- 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:

--

-- 12

-- ==

--

-- 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:

ORACLE SQL

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