UMGC Ten SQL Statements and Results Lab – Description
In this lab you will write the 10 SQL statements against the STUDENT schema in Oracle. Your statements should run error-free and should be valid. Submit two separate files: one plain text file (.txt or .sql file) with your statements only (non-code should be properly commented); and the other document (doc/docx/pdf) include both your statements and your query results (copy and paste text or screen shots). The instructor should be able to run your plain text source file as script and generate the same output as shown in your result document.
Q1. List all information about all instructors
Q2. Display the following information about all grade types:
Grade Type Code (name the column as “Grade Type Code”) and Full Description (format: code – description; for example “FI – Final”; name the column as “Full Description”)
Q3. Add yourself as a new instructor to the Instructor table (use sequence INSTRUCTOR_ID_SEQ.NEXTVAL as Instructor_ID and 10015 as zip)
Q4. List all instructors who live in zip 10015. Display Instructor_ID, first name, last name, phone, street address and zip. Do not show created_by/date or modified_by/date
q5. List all students who live in zip 07036 and with Thomas as either first name or last name. Display student ID, first name, last name, street address and zip
Q6. Show the number of Programming courses (display the final count for any course that has “Programming” in it’s description. HINT: use COUNT and LIKE operator)
Q7. List all New York state (NY) or New Jersey state (NJ) zipcodes that belong to a city with name starting with a “N” but it’s not New York nor Newark. Display zip, city, and state
Q8. Update your own instructor record added for query 3 and change the zip from 10015 to 23456
Q9. List all instructors (Display Instructor_ID, first name, last name, and zip only). Sort results first by zip in descending order (instrucor without zip should appear first), and then by Insturctor_ID in ascending order
Q10. Delete your own instructor record added for query 3
The post UMGC Ten SQL Statements and Results Lab first appeared on .
