Question
-- QUESTION 7 -- ========== -- -- Which were the showings with the most performances? In which cinema were, -- they shown, on which screen
-- 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:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started