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.
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)
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started