USING APEX

1. Write a SQL statement using employees table to display the department ID, the highest salary, and the sum of all the employees salary for every department, arranged by sum of salary from the highest to the lowest.

2. Write a SQL statement using employees table to display the department ID and average salary where department ID is higher than 50, grouped by department ID, and sorted by department ID.