Help with statements
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.