SELECT p.first_name || || p.last_name AS employee_name, SUM(h.hours_worked) AS total_hours_worked FROM persons p INNER JOIN employees e ON p.id = e.person_id LEFT JOIN hours h ON e.id = h.employee_id GROUP BY e.id