5-5. Develop a query to find the instructor name and course name for computer science courses (use the Section table). Order the table by instructor name. a. Convert your query into a view. b. Remove the ORDER BY clause and convert the query into an inline view with column aliases and test it. c. Put the ORDER BY clause outside of the inline view in the main query and run your query again.

Student

stno NOT NULL NUMBER (3)

PRIMARY KEY NOT NULL

sname VARCHAR2(20)

major CHAR(4)

class NUMBER(1)

bdate DATE

Grade

student_number NOT NULL NUMBER(3)

section_id NOT NULL NUMBER(6)

grade CHAR(1)

PRIMARY KEY (student_number, section_id)

Section

section_id NOT NULL NUMBER(6)

PRIMARY KEY NOT NULL

course_num CHAR(8)

semester VARCHAR2(6)

year CHAR(2)

instructor CHAR(10)

bldg. NUMBER(3)

room

Course;

Name Null? Type

----------------------------------------- -------- ----------------------------

COURSE_NAME VARCHAR2(20)

COURSE_NUMBER NOT NULL VARCHAR2(8)

CREDIT_HOURS NUMBER(38)

OFFERING_DEPT VARCHAR2(4)