Reports

SELECT CONCAT(e.FirstName, ' ', e.LastName) AS [Name],
       CONCAT(ISNULL(closedReports.CountedClosed, 0), '/', ISNULL(openReports.CountedOpen, 0)) AS [Closed Open Reports]
 FROM Employees AS e
LEFT JOIN
(SELECT EmployeeId, COUNT(*) CountedClosed FROM Reports
WHERE DATEPART(YEAR, OpenDate) <= '2016' AND DATEPART(YEAR, CloseDate) = '2016'
GROUP BY EmployeeId) AS closedReports
ON closedReports.EmployeeId = E.Id
LEFT JOIN
(SELECT EmployeeId, COUNT(*) CountedOpen FROM Reports
WHERE DATEPART(YEAR, OpenDate) = '2016'
GROUP BY EmployeeId) AS openReports
ON openReports.EmployeeId = e.Id
WHERE (closedReports.CountedClosed IS NOT NULL OR openReports.CountedOpen IS NOT NULL) AND (openReports.CountedOpen IS NOT NULL)
ORDER BY [Name] ASC, e.Id