Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

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)

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced MySQL 8 Discover The Full Potential Of MySQL And Ensure High Performance Of Your Database

Authors: Eric Vanier ,Birju Shah ,Tejaswi Malepati

1st Edition

1788834445, 978-1788834445

Students also viewed these Databases questions