5. Write a query which joins the faculty table with the faculty_department table with the department table. The query should return the first_name and last_name from the faculty table, and the name column from the department table. This should be an inner join.

6. Write a query which identifies both the faculty who have been assigned to a department, and the faculty who have NOT been assigned to a department (no corresponding records in the faculty_department table). The query should return the faculty first name and last name and the name of the department. This query should use an outer join.

Department- Department_id, Name

Faculty- faculty_id, first_name, last_name

faculty_department- faculty_id, dpeartment_id