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 Modern Times Parasite £63,571 £58,332 £37,195 £34,362 39 38 23 Knives Out 22 Citizen Kane 25 The Wizard of Oz Avengers: Endgame £32,711 £21,716 £17,081 18 18 Type your query below:

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
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
£58,332
Modern Times
38
Parasite
£37,195
£34,362
23
Knives Out
22
Citizen Kane
25
£32,711
£21,716
The Wizard of Oz
18
Avengers: Endgame
18
£17,081
Type your query below:
Transcribed Image Text: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 £58,332 Modern Times 38 Parasite £37,195 £34,362 23 Knives Out 22 Citizen Kane 25 £32,711 £21,716 The Wizard of Oz 18 Avengers: Endgame 18 £17,081 Type your query below:
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY