SQL 6 Help

jamesT77

SQL help

  • a year ago
  • 75
files (4)

Lesson6Exercises.docx

complete exercises 2, 3, 4, 5, 6, and 8 from Chapter 6. For each exercise, you need to create SQL statements and related CSV files. Here's what you need to do:

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

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

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

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

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

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

Submission Instructions

Place all your SQL files (6) and CSV files (6) in a folder labeled "Lesson 6".

Replace "MEID" in the file names JAM2334209.

Zip the entire "Lesson 6" folder as described in the Syllabus.

Submit the assignment folder using the link below.

Screenshot21.png
This file is too large to display.View in new window
Screenshot20.png
This file is too large to display.View in new window
CIS276DA_MurachDataFiles.zip
This file is too large to display.View in new window