Help with SQL Questions In Assignment?

[bingbongbangbung]

This first question, I gotta make a block that outputs employee id, first name and last name, and their department name by location from employees, departments, and locations tables. They need to be listed with employees at top, followed by locations lacking employees nor departments. Finally I have to print a custom message for locations lacking them; the hint is to examine table relations.

For the other question, I'm supposed to make a block that outputs that shows employee id, their first and last names, department name, their manager's name from both departments and employees table. I'm supposed to list by department and only if the department has employees; the only hint given was to examine table relations.

Updates

+1 y

i figured it out after a classmate told me