Question: Please help write a single script (with comments at the top) Make sure you PRINT each question before you write the query to SELECT the

Please help

write a single script (with comments at the top)

Make sure you PRINT each question before you write the query to SELECT the results.

15. Provide an alphabetic list of students (by the Students Full Name with last name first) who have an overall grade average of 93 or higher. The results should be sorted on Students Full name (showing last name first). (3 Rows)

16. List the names and address (including city and state) for all faculty who have taught less than 10 course sections. (2 Rows)

17. List the course number and number of students enrolled in courses that do not have a prerequisite. Sort the list by number of students enrolled from highest to lowest. (4 Rows)

18. Provide an alphabetic list of students (first and last names) their enrollment date(s), and count of their enrollment(s) for that date, who are from Flushing, NY and who enrolled prior to February 7, 2007. (2 Rows)

19. Provide a listing of course numbers, descriptions, and formatted (with $) costs, that include projects (Grade_type_code = 'PJ') as a part of their grading criteria. (9 rows)

20. List the highest grade on the final exam (Grade_type_code = 'FI') that was given to a student in course 145. (1 Row)

Please help write a single script (with comments at the top) Make

GRADE STUDENTLID STUDENT STUDENTLID ENROLLMENT STUDENTLID 8 SECTIONLD 8 GRADE TYPE CODE 8 GRADE CODE OCCURRENCE SALUTATION FIRST NAMIE LAST NAME STREET ADDRESS ZP PHONE EMPLOYER REGISTRATION DATE CREATED_BY CREATED DATE MODIFIED BY MODIFIED DATE ENROLL DATE FINAL GRADE CREATEDBY CREATEDDATE MODFIED_BY MODIFIED DATE NUMERIC GRADE COMMENTS CREATEDBY CREATED DATE MODFIED_BY MODIFIED DATE GRADE CONVERSION 8 LETTER GRADE GRADE POINT MAX GRADE MIN GRADE CREATED_BY CREATED DATE MODIFIED_BY MODIFIED DATE GRADE TYPE WEIGHT SECTIONLID 8 GRADE TYPE CODE SECTION SECTIONLD COURSE NO SECTION NO START DATE TIME LOCATION INSTRUCTORLID CAPACITY CREATED_BY CREATED DATE MOD FIED_BY MODIFIED DATE NUMBER PER SECTION PERCENT OF FINAL_GRADE DROP LOWEST CREATEDBY CREATED_DATE MODIFIED_BY MODIFIED DATE GRADE TYPE 8 GRADE TYPE CODE DESCRIPTION CREATEDBY CREATED_DATE MOD FIED_BY MODIFIED DATE INSTRUCTOR 8 INSTRUCTOR ID COURSE SALUTATION FIRST NAME LAST NAME STREET_ADDRESS ZP PHONE CREATEDBY CREATED_DATE MODIFIED_BY MODIFIED DATE 8 COURSE NO ZIPCODE COST PREREQUISITE CREATEDBY CREATED_DATE MOD FIED_BY MODIFIED DATE 8 ZIP CITY STATE CREATEDBY CREATED_DATE MODIFIED_BY MODIFIED_DATE GRADE STUDENTLID STUDENT STUDENTLID ENROLLMENT STUDENTLID 8 SECTIONLD 8 GRADE TYPE CODE 8 GRADE CODE OCCURRENCE SALUTATION FIRST NAMIE LAST NAME STREET ADDRESS ZP PHONE EMPLOYER REGISTRATION DATE CREATED_BY CREATED DATE MODIFIED BY MODIFIED DATE ENROLL DATE FINAL GRADE CREATEDBY CREATEDDATE MODFIED_BY MODIFIED DATE NUMERIC GRADE COMMENTS CREATEDBY CREATED DATE MODFIED_BY MODIFIED DATE GRADE CONVERSION 8 LETTER GRADE GRADE POINT MAX GRADE MIN GRADE CREATED_BY CREATED DATE MODIFIED_BY MODIFIED DATE GRADE TYPE WEIGHT SECTIONLID 8 GRADE TYPE CODE SECTION SECTIONLD COURSE NO SECTION NO START DATE TIME LOCATION INSTRUCTORLID CAPACITY CREATED_BY CREATED DATE MOD FIED_BY MODIFIED DATE NUMBER PER SECTION PERCENT OF FINAL_GRADE DROP LOWEST CREATEDBY CREATED_DATE MODIFIED_BY MODIFIED DATE GRADE TYPE 8 GRADE TYPE CODE DESCRIPTION CREATEDBY CREATED_DATE MOD FIED_BY MODIFIED DATE INSTRUCTOR 8 INSTRUCTOR ID COURSE SALUTATION FIRST NAME LAST NAME STREET_ADDRESS ZP PHONE CREATEDBY CREATED_DATE MODIFIED_BY MODIFIED DATE 8 COURSE NO ZIPCODE COST PREREQUISITE CREATEDBY CREATED_DATE MOD FIED_BY MODIFIED DATE 8 ZIP CITY STATE CREATEDBY CREATED_DATE MODIFIED_BY MODIFIED_DATE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!