Listing C

select

        (select max(salary) from emp)                  highest_salary,

        emp_name                                            employee_name,

        (select avg(bonus) from commission)         avg_comission,

        dept_name

from

        emp,

        (select dept_name from dept where dept = ‘finance’)

;