Homework 05: SQL Data Manipulation Consider the Agents table from Lab 02: Agents (agentNo,fName,IName,branchNo,salary,dob,address,city,county,state,zip,phonel,phone2,email) Provide the SQL statements that display the followings: aki 1 List the agent number, the first and last names, the state, and the salary of all agents sorted in the ascending order of the state and the descending order of the salary. Produce a list for all agents, showing the agent number, the first and last names, and the monthly salaries (salary/12). Use the AS clause to name the last column monthlySalary. 2- 3- List the agent number, the first and last names, the address, the city, the state, and the salary of all agents with a salary greater than $50000. 4- List the agent number, the first and last names, the address, the city, the state, and the salary of all agents with a salary greater than $50000 and living in either NY state or MI state Note: In this task, parenthesis should be used appropriately