SELECT t1.`name`, CONCAT(IF(t2.`closed_date`, t2.`closed_date`, 0), '/', IF(t1.`opened_date`, t1.`opened_date`, 0)) AS `closed_open_reports` FROM

(SELECT CONCAT(e.first_name, ' ', e.last_name) AS `name`, COUNT(*) AS `opened_date` FROM employees AS e
LEFT JOIN reports AS r ON e.id = r.employee_id
WHERE YEAR(r.open_date) = 2016
GROUP BY `name`) AS t1

LEFT JOIN

(SELECT CONCAT(e.first_name, ' ', e.last_name) AS `name`, COUNT(*) AS `closed_date` FROM employees AS e
LEFT JOIN reports AS r ON e.id = r.employee_id
WHERE YEAR(r.close_date) <= 2016
GROUP BY `name`) AS t2

ON t1.`name` = t2.`name`
ORDER BY t1.`name`;