12.e.    Get a list of all of the courses that each professor has taught, listed by professor name and course name, ordered by professor name.

 

Commands

Output

select prof_name, course_name

from professors, teach, courses

where professors.prof_id = teach.prof_id

and teach.course_id = courses.course_id

order by prof_name;

 

PROF_NAME            COURSE_NAME

Adams                        Intermed. Acct.

Adams                       Adv. Acct

Kirs                            Database

Mahapatra                  Database

Mahapatra                 COBOL

Mahapatra                 Networks

Mahapatra                 Syst. Analysis

Thomas                     Basic Acct

 

8 rows selected.