Commands

Output

Select course_name, dept_name

From courses, department, professors, teach

Where department.dept_id = professors.dept_id

And professors. Prof_id = teach.prof_id

And teach.course_id = courses.course_id

Order by course_name;

COURSE_NAME          DEPT_NAME

Adv. Acct                       Accounting

Basic Acct                      Accounting

COBOL                          Infosys

Database                         Infosys

Database                         Infosys

Intermed. Acct.               Accounting

Networks                        Infosys

Syst. Analysis                 Infosys

8 rows selected.