1. Create a query to display the full name, and salary for all employees who were hired before King; and whose salary is not in the range of $4,850 and $11,680. Full Name Simon De Haan Andrew Matos SALARY 17000 3487 2. Display the last name and annual salary and department name of all employees who have an a and an e in their department name. And display them in descending order of the name LAST NAME Siam Moris Annual Salary 129800 980300 Department Name Sales Finance 3. Display the manager name and the salary of the lowest paid employee for that manager. Exclude anyone who earns a commission. Exclude any groups where the average salary is less than 8000. Sort the output in descending order of salary. 4. Display the last name, department number, and job ID of all employees whose department is in Toronto