Need help writing SQL for the following

!

Return the names and annual salary of the 15 lowest performing employees. For each employee, list their full name and "daily salary" assuming 248 working days per year. List the max, min, avg, and total sum of annual salary as well as count for employees of the engineering department. List employees and the names of the projects they are working on (one record for each employee/project combination). Only include employees who are assigned to projects. Repeat #8, but this time include all employees even if they are not currently assigned a project. [this a trick question. Explain why] Repeat #8, aliasing the project table as PT and the employee table as EMP. Modify the query as needed to run. Return the names and annual salary of the 15 lowest performing employees. For each employee, list their full name and "daily salary" assuming 248 working days per year. List the max, min, avg, and total sum of annual salary as well as count for employees of the engineering department. List employees and the names of the projects they are working on (one record for each employee/project combination). Only include employees who are assigned to projects. Repeat #8, but this time include all employees even if they are not currently assigned a project. [this a trick question. Explain why] Repeat #8, aliasing the project table as PT and the employee table as EMP. Modify the query as needed to run