SQL 7 Help

You are required to complete the following exercises from Chapter 7: #1, 3, 5, 7, 8, 9.

For each exercise, you need to create SQL statements and related CSV files. Here's what you need to do:

Exercise 1: Write your SQL statement in a file named CIS276DA_Lesson7Exercise1_JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson7Exercise1_JAM2334209.csv.

Exercise 3: Write your SQL statement in a file named CIS276DA_Lesson7Exercise3_JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson7Exercise3_JAM2334209.csv.

Exercise 5: Write your SQL statement in a file named CIS276DA_Lesson7Exercise5_JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson7Exercise5_JAM2334209.csv.

Exercise 7: Write your SQL statement in a file named CIS276DA_Lesson7Exercise7_JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson7Exercise7_JAM2334209.csv.

Exercise 8: Write your SQL statement in a file named CIS276DA_Lesson7Exercise8_JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson7Exercise8_JAM2334209.csv.

Exercise 9: Write your SQL statement in a file named CIS276DA_Lesson7Exercise9_JAM2334209.sql. Run the script and export the results to CIS276DA_Lesson7Exercise9_JAM2334209.csv.