please solve using oracle sql

$1.$ For each employee, list their SSN and last name and the names and hours worked of the project$($s$)$ they work the most hours per week on$.$

$2.$ Retrieve the last name of each employee, whether they manage a department or not, along with the names of the departments they manage. If an employee does not manage a department, then NULLs should be displayed for the department name: we want to see all employees.