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.

7. Create a query to determine the number of sections in which student ID 250 is enrolled. Your output should contain the student ID and the number of sections (alias) enrolled.

(1 Row)

8. List the section ID and lowest quiz score (GRADE_TYPE_CODE='QZ') for all sections where the low score is greater than a B (greater than 80). Arrange by section id.

(16 rows)

9. List the names of Employers having more than 5 student employees. Your output should contain the employer name and the number of student employees. Arrange the output on the number of employees from lowest to highest. (4 Rows)

10. List the section ID, number of participation grades (GRADE_TYPE_CODE='PA') and lowest participation grade for all sections with more than 15 participation grades. Arrange by section id.

(6 Rows)

11. List the first and last name and phone number for students that live in Newark, NJ. Sort on last name and first name. (3 Rows)

12. For all 300 level courses (300-399), list the course number, prerequisite course number and prerequisite course description. Sort by course number. (2 Rows)

13. List the course number and description for all 100-level courses taught by Charles Lowry. Arrange the list in order of course number. (6 rows)

14. List the grade type code, description and number per section of all grades in course 144. Arrange by description. (5 Rows)

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

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

Database Programming With Visual Basic .NET

Authors: Carsten Thomsen

2nd Edition

1590590325, 978-1590590324

More Books

Students also viewed these Databases questions

Question

Explain the function and purpose of the Job Level Table.

Answered: 1 week ago