SQL 5

jamesT77

SQL Help

  • a year ago
  • 75
files (4)

Lesson5Exercises.docx

CIS276DA_Lesson4Exercise7_JAM2334209

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

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

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

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

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

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

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

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

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

Submission Instructions

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

Replace "MEID" in the file names with your actual JAM2334209.

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

Submit the zipped assignment folder using the link below.

Screenshot18.png
This file is too large to display.View in new window
Screenshot19.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