Task 7 OUTER JOINs

Question 1

Find the list of all buildings that have employees

Answer 1

SELECT DISTINCT building FROM employees;

Question 2

Find the list of all buildings and their capacity

Answer 2

SELECT * FROM buildings;

Question 3

List all buildings and the distinct employee roles in each building (including empty buildings)

Answer 3

SELECT DISTINCT building_name, role
FROM buildings
LEFT JOIN employees
ON building_name = building;