SELECT p.first_name || || p.last_name AS employee_name, COUNT(l.id) AS total_leaves_taken FROM persons p INNER JOIN employees e ON p.id = e.person_id LEFT JOIN leaves l ON e.id = l.employee_id GROUP BY e.id