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.
List the salutation and names (first and last name) of all instructors in alphabetical order (last name then first name).
10 rows selected
Provide a list of distinct locations that have been used to teach sections of courses. Arrange the list in order of location.
12 rows selected
List the first and last names of Instructors with a first name starting with T. Sort them in alphabetical order.
rows selected
List the phone number, full name (as one column) and employer for all students with a last name of Torres. Sort by Employer
rows selected
List the course number and course description of all courses that have a prerequisite of course
350. Arrange in order of course number.
2 rows selected
List the course number, description and cost for all 200 level courses (200-299) costing less than
$1100. Arrange by course number. Format and add a $ in front of the COST.
2 rows selected
List the course number, section id and location for all 100 level courses (100 through 199) that are taught in room L214 or L509. Order by location and course number
26 rows selected

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
Get step-by-step solutions from verified subject matter experts
