QUESTION 8 name, Produce a report for all showings of "Casablanca", providing the film 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 per seat Takings per person Takings 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 O -- Grange Cinema Masterton Multiplex The Glory Showhouse ANN 20 27 15 -- Type your query below: -- 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