Please answer completely and correctly!

Consider the following scherma information and answer the questions that follow DEPARTMENTS (DEPARTMENT JD number, DEPARTMENT NAME varchar2, MANAGER ID number, LOCATION ID number; EMPLOYEES EMPLOYEE IO number, FIRST NAME van har2 LAST NAME va ha 2. EMAL va cha 2, PHONE NUMBER ar har2 HIRE DATE date, JOE D arch 2, SALARY number, COMMISSION-PCT number, DEPARTMENTJD number, MANAGER-ID 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 JD char 1. Write SOL. statement to getall employees who earn mote than 6499. Your result should include employees' first name, last name, department ID, and salary. Sort your result by salary, from largest to smallest employee count.Sort your result by the employee count. 2. Write SOL statement to show each department with the number of employoes who work in that department. Your result should include the department name and the . 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 name, and salary. 4. Write SQL. statement to list managers. Your result should show managors' first name, last name, the department name and how many employees they manage. Sort your result by last name. 5. Wirite SOL statement to find location information in which street address contains s. Your result should list location ID, stroot addross, and city