USE report_service;
SELECT DISTINCT d.name, c.name,
FROM departments AS d
JOIN categories AS c
ON d.id = c.department_id
RIGHT JOIN reports AS r
ON c.id = r.category_id
ORDER BY d.name, c.name;