Use MySQL workbench to write one SQL statement to answer question. Do not use views or temporary tables to answer the questions. 

To set up the database in your MySQL server, download the file asst2-2019s1-setup.sql from LMS and run it in Workbench. This script creates the database tables and populates them with test data.