Please answer completely and correctly! Only ?s 4 & 5

Consider the following scherma information and answer the questions that follow DEPARTMENTS (DEPARTMENT JD number, DEPARTMENT NAME varchar2, MANAGER ID number, LOCATION JD number EMPLOYEES EMPLOYEE IO number, FIRST NAME van 2 LAST NAME v ha 2. EMAL va ch 2 PHONE NUMBER var har2, HIRE DATE date, JOE D arch 2, SALARY number, COMMISSION PCT number, DEPARTMENT ID number, MANAGER JD number; JOBS (JOBJD varchar2, JOB TITLE varchar2, MIN SALARY number,MAX SALARY number) LOCATIONS (LOCATION JD number, STREET ADDRESS varchar2, POSTAL CODE varchar2, CITY varchar2, STATE PROVINCE varchar2, COUNTRY ID char; 1. Write SQL statement to get all employees who earn more than 6499. Your result should include employees' first name, last name, department ID, and salary. Sort your result by salary, from largest to smallest 2. Write SQL statement to show each department with the number of employees who work in that department. Your result should include the department name and the employee count.Sort your result by the employee count. name, and salary your result by last name. . Write SQl. statement to find which department has the most expensive employee. Your results should show the department name, the employee's first name, last 4. Write SQ statement to list managers. Your result should show managens fist name, ast narhe, the department name and how many employees they manage. Sort 5, Write SOL statement to find location information in which street address contains st Your result should ist location ID, streot addross, and city