10 ot 22.10.2017 exam

SELECT CONCAT(e.FirstName,' ',e.LastName) AS 'Name',COUNT(*) AS 'Users Number'
FROM [Employees] AS e
LEFT JOIN [Reports] AS r ON e.Id=r.EmployeeId
LEFT JOIN [Users] AS u ON r.UserId=u.Id
GROUP BY e.FirstName,e.LastName
ORDER BY 'Users Number' DESC,'Name' ASC