70 pts] Write/Run SQL queries for the following use cases (no screenshots of these queries and their input/output needed). a. [5 pts] Retrieve the name and salary of all employees. b. [5 pts] Retrieve the name and address of all employees who work for the 'Sales' department. c. [5 pts] Retrieve the name and address of all employees who work either for the 'Sales' or Administration department. d. [5 pts] Retrieve the name and address of all employees who work either for the 'Sales' or Administration department, sorted alphabetically by last name, then first name. e. [5 pts] Retrieve all employees in the research department whose salary is between $30,000 and $40,000. f. [5 pts] List all name of employees, the projects that they have been working on, and the amount of time they spent for those projects.

g. [5 pts] Retrieve all employees whose address is in Atlanta, GA. h. [5 pts] List all the department names which are located in Houston. i. [5 pts] Retrieve all distinct salary values of very employee. j. [5 pts] A new person whose name is Joshua T Miller has been hired. Add this new employed person to the system along with his following information: SSN: 456363313 birth date: 1971-10-18 address: 98 Oak Forest, Katy, TX salary: 37000 superssn: 456363313 dno: 4 k. [5 pts] Joshuas salary has been increased with 10%. Make the required update.

l. [5 pts] Joshua left the company after working 3 years. Delete his personal record from the system. m. [10 pts] Make a list of all project numbers and project names for projects that involve an employee whose last name is 'Smith', either as a worker or as a manager of the department that controls the project.