Using the MySQLsakila test/sample database (available at: http://mysql-tools.com/en/downloads/mysql-databases/4-sakila-db.html) please provide SQL statements for the questions in the attached picture.

Question 8: Write a SQL statement that lists the following information. No row should appear more than once in the output. Order your results by customer last name, then by customer first name. Include your results. customer id customer last name customer first name customer email average rental amount most recent rental date most recent return date Question 9: Write a SQL statement that gives the customer counts by country, district, and postal code. No row should appear more than once. Order your results by country then district, then postal code. Include your results. List the following information in your output: district city postal code customer count Question 10: Write a SQL statement that gives the total revenue by postal code. No row should appear more than once. Order your results by country, then district, then postal code. Include your results. List the following information in your output: district city postal code revenue