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

Please help write a single script (with comments at the top Make

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!