Tables are as follows (For reference purposes):

TABLE COURSES

TABLE STUDENTS

TABLE INSTRUCTORS

TABLE CLASSES

TABLE ENROLLMENTS

6. Write a query to display stu_id column, first_name column, and last_name column from students table, classes table, instructors table, and enrollments table. Display all students stu_id, first_name, and last_name data if students have taken classes with Professor Gunther Haas.

7. Write a query to display instructor_id column, first_name column, last_name column, and work_phone column from instructors table and classes table. Display all instructors instructor_id, first_name, last_name, and work_phone data if instructor(s) has or have taught more than one different course.

8. Write a query to display stu_id column, first_name column, and last_name column from students table and other tables. Display all students stu_id, first_name, and last_name data if students have only taken the first period classes.

COURSE_ID TITLE DURATION DURAT DATE_FIRS DATE_LAST DELIVERY SECTION_CODE 1001 Introduction to PL/SQL 1002 Algebra I 1003 Calculus I 1004 Java Programming II 17 Weeks 08-JAN-04 17 Weeks 08-JAN-02 17 Weeks 08-JAN-02 34 Weeks 08-JAN-02 In-class In-class In-class In-class 2005 2001 2001 2005 STU_ID FIRST_NAME LAST_NAME CONTACT_PHO EMAIL EXPECTED_ADDRESS1 ADD CITY ST POSTA COUNTRY 101 Mary 102 Jennifer 103 Jennifer 104 Jack 105 Frank Lou Loppez Johnsons Bason Davis 919-8665360 mlou@gmail.com 20-MAY-20 234 Lynn Road 919-8665359 jloppez@gmail.com 20-MAY-20 110 Six Forks Road 919-8665350 jjohnsons@gmail.com 20-MAY-20 124 Spring Road, 919-8665340 jbason@gmail.com 20-MAY-20 789 New Berns Road 919-8665330 fdavis@gmail.com 20-MAY-20 119 Ray Road Raleigh NC 27612 USA Raleigh NC 27614 USA Raleigh NC 27617 USA Raleigh NC 27619 USA Raleigh NC 27610 USA INSTRUCTOR_ID FIRST_NAME LAST_NAME WORK_PHONE EMAIL, OFFICE_LOCATION OS 3001 Jennifer 3002 Richard 3003 Gunther Jacobs Santos Haas 555-2399876 555-2399955 555-2395429 Bldg. 10 Room 52 Bldg. 10 Room 52 Bldg. 10 Room 53 CLASS_ID START_DAT PERIOD FREQUENCY INSTR_ID COURSE_ID 1 08-DEC-04 First 2 08-DEC-04 Second 3 08-DEC-04 Fifth 4 08-DEC-04 Mon-Wed 5 08-DEC-04 First 6 08-DEC-04 Mon-Wed Daily Daily Daily Weekly Daily Weekly 3003 3003 3003 3001 3001 3001 1002 1002 1002 1001 1003 1004 6 rows selected. ENROLLMEN CLASS_ID STU_ID FINAL_NUMERIC_GRADE F STATUS 12-JAN-04 12-JAN-04 12-JAN-04 12-JAN-04 eHHHH 101 102 103 104 Enrolled Enrolled Enrolled Incomplete