Question
-- QUESTION 3 -- ========== -- -- Lec Dombrovski has phoned in sick, Create a query to report the name and phone -- number of
-- QUESTION 3
-- ==========
--
-- Lec Dombrovski has phoned in sick, Create a query to report the name and phone
-- number of his supervisor.
--
-- Solution Test:
-- NAME PHONE_NO
-- ----------------------------------------- -----------
-- Petr Cillich 04992730026
--
-- Type your query below:
-- QUESTION 4
-- ==========
--
-- Write a report of all films shown in August 2021 more than 16 times, give the films name,
-- how many performances of these films there were and how much those films took in total
-- over that period. List the films by the film that took the most money first, and provide
-- meaningful headings to the columns in the output as shown in the Solution Test below.
--
-- Hint:
--
-- Solution Test:
-- FILM_NAME Performances Total Takings
-- --------------------------- ------------ ----------------------
-- It Happened One Night 39 63,571
-- Modern Times 38 58,332
-- Parasite 23 37,195
-- Knives Out 22 34,362
-- Citizen Kane 25 32,711
-- The Wizard of Oz 18 21,716
-- Avengers: Endgame 18 17,081
--
-- Type your query below:
-- QUESTION 5
-- ==========
--
-- Report how much each cinema took on the 12th August, the report should
-- include the name of the cinema and the value of the takings in the report.
-- Order by highest takings first. The output should also be formatted as
-- shown below.
--
-- Cinema Takings on August 12
-- ------------------------------ ----------------------
-- Masterton Multiplex 5,731
-- The Glory Showhouse 2,424
-- Grange Cinema 1,974
-- Treban Picturehouse 1,719
-- Marvale Rex 1,005
--
-- Hint: Use the format operator (L) to create the use of the
-- symbol.
--
-- Solution Test:
--
-- Type your query below:
-- QUESTION 6
-- ==========
--
-- List the age in years of the oldest employee at each cinema. Order the report by the
-- cinema with the most employees first. Output should be formatted as below.
--
-- Hint: Use the examples in the SQL Sessions to determine the age in years of staff.
--
-- Solution Test:
--
-- Cinema Oldest Employee
-- -------------------------------------------------- ----------------
-- Masterton Multiplex 56
-- Grange Cinema 48
-- The Glory Showhouse 52
-- Marvale Rex 62
-- Odeon on the Hill 61
-- Flix 57
-- Treban Picturehouse 34
--
-- 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