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 Modern Times Parasite Knives Out Citizen Kane The Wizard of Oz Avengers: Endgame 39 38 23 22 25 18 18 NNN 00 00 N W010! 163,571 58,332 37,195 34, 362 32,711 21,716 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 The Glory Showhouse Grange Cinema Treban Picturehouse Marvale Rex 5,731 2,424 1,974 1,719 1,005 Hint: Use the format operator (L) to create the use of the symbol. Solution Test: III Type your query below