SELECT name, CONCAT(closed, '/', `open`) as closed_open_report FROM (SELECT CONCAT(e.first_name, ' ', e.last_name) AS name,
		SUM((SELECT COUNT(r2.id) FROM reports as r2
		WHERE close_date >= DATE('2016-01-01') AND close_date <= DATE('2016-12-31')
		AND r2.id = r1.id)) AS closed,
		SUM((SELECT COUNT(r2.id) FROM reports as r2
		WHERE (((open_date > DATE('2016-01-01') AND open_date < DATE('2017-01-01'))
		AND r2.id = r1.id)))) AS `open` FROM reports as r1
JOIN employees as e ON r1.employee_id = e.id
GROUP BY name HAVING closed != 0 OR `open` != 0) AS results
ORDER BY name;