1).what would be the select statement to show ,for every department in which the average salary >$50,000,the highest salary paid to the employees of the department.

Answer

========

select dept_name,max(emp_salary) as MaxSalary from...