12.b.    Get a list of all the faculty members (listed by department name and professor name), ordered by department.

 

Commands

Output

Select dept_name, prof_name

From department, professors

Where department.dept_id = professors.dept_id

Order by dept_name;

DEPT_NAME      PROF_NAME

Accounting           Adams

Accounting           Thomas

Infosys                  Kirs

Infosys                  Mahapatra

 

4 rows selected.