9. Write a SELECT statement based on the tables in the third normal form from your response to

Question 2. Include at least 1 join and 1 filter clause.