TASK 8 A short note on NULLs

Question 1

Find the name and role of all employees who have not been assigned to a building

Answer 1

SELECT name, role FROM employees
WHERE building IS NULL;

Question 2

Find the names of the buildings that hold no employees

Answer 2

SELECT DISTINCT building_name
FROM buildings
LEFT JOIN employees
ON building_name = building
WHERE role IS NULL;