Executive Solution Overview
Help with statements – 2 years ago **files (3)** – ## Lesson7Exercises.docx – Screenshot37.png – Screenshot38.png **## Lesson7Exercises.docx** 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 …
Assignment Prompt & Instructions
Help with statements
– 2 years ago
**files (3)**
– ## Lesson7Exercises.docx
– Screenshot37.png
– Screenshot38.png
**## Lesson7Exercises.docx**
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.
**Screenshot37.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot37-png-10209969)
**Screenshot38.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot38-png-10209971)
**Screenshot38.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot38-png-10209971)
**## Lesson7Exercises.docx**
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.
**Screenshot37.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot37-png-10209969)
**Screenshot38.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot38-png-10209971)
**## Lesson7Exercises.docx**
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.
**Screenshot37.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot37-png-10209969)
**Screenshot38.png**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/screenshot38-png-10209971)