Need quick help adjusting this code, the problem it is trying to solve is: List the instructors who teach Advanced Java Programming, without duplication. Show instructor name and course name.

I have:

SELECT INSTRUCTOR.FIRST_NAME, INSTRUCTOR.LAST_NAME, COURSE.DESCRIPTION FROM INSTRUCTOR, COURSE

INNER JOIN SECTION ON SECTION.COURSE_NO=COURSE.COURSE_NO

WHERE SECTION.COURSE_NO= (

SELECT COURSE_NO FROM COURSE WHERE COURSE.DESCRIPTION= 'ADVANCED JAVA PROGRAMMING')

GROUP BY INSTRUCTOR.FIRST_NAME, INSTRUCTOR.LAST_NAME, COURSE.DESCRIPTION ;

Tables from database

Name Null Type

------------- -------- ------------ENROLLMENT TABLE

STUDENT_ID NOT NULL NUMBER(8)

SECTION_ID NOT NULL NUMBER(8)

ENROLL_DATE NOT NULL DATE

FINAL_GRADE NUMBER(3)

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE

Name Null Type

--------------- -------- ------------SECTION TABLE

SECTION_ID NOT NULL NUMBER(8)

COURSE_NO NOT NULL NUMBER(8)

SECTION_NO NOT NULL NUMBER(3)

START_DATE_TIME DATE

LOCATION VARCHAR2(50)

INSTRUCTOR_ID NOT NULL NUMBER(8)

CAPACITY NUMBER(3)

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE

Name Null Type

------------- -------- ------------COURSE TABLE

COURSE_NO NOT NULL NUMBER(8)

DESCRIPTION NOT NULL VARCHAR2(50)

COST NUMBER(9,2)

PREREQUISITE NUMBER(8)

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

Name Null Type

-------------- -------- ------------Instructor table

INSTRUCTOR_ID NOT NULL NUMBER(8)

SALUTATION VARCHAR2(5)

FIRST_NAME VARCHAR2(25)

LAST_NAME VARCHAR2(25)

STREET_ADDRESS VARCHAR2(50)

ZIP VARCHAR2(5)

PHONE VARCHAR2(15)

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE

Name Null Type

----------------- -------- ------------STUDENT TABLE

STUDENT_ID NOT NULL NUMBER(8)

SALUTATION VARCHAR2(5)

FIRST_NAME VARCHAR2(25)

LAST_NAME NOT NULL VARCHAR2(25)

STREET_ADDRESS VARCHAR2(50)

ZIP NOT NULL VARCHAR2(5)

PHONE VARCHAR2(15)

EMPLOYER VARCHAR2(50)

REGISTRATION_DATE NOT NULL DATE

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE

Name Null Type

------------- -------- ------------ZIPCODE TABLE

ZIP NOT NULL VARCHAR2(5)

CITY VARCHAR2(25)

STATE VARCHAR2(2)

CREATED_BY NOT NULL VARCHAR2(30)

CREATED_DATE NOT NULL DATE

MODIFIED_BY NOT NULL VARCHAR2(30)

MODIFIED_DATE NOT NULL DATE