SQL HELP PLEASE

Show the SQL query commands (MySQL or SQLite) that can be used to generate the following data that goes into a Status Report for upper management: a. All managers who currently have no direct reports; are not managing any employees) b. The total worth of all the contracts the company currently has. c. The total salaries of all employees in each department d. The minimum and maximum salary for each department. e. Listing of all employees who reside in the same city, grouped by city f. Employees who make at least $73000. g. The average salary of the employees, for the whole company; and by dept. h. Employees who do not have a company (av.com) email address as their contact information