Advertisement
Guest User

Untitled

a guest
Jun 21st, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.33 KB | None | 0 0
  1. SELECT Name, SUM([Users Number]) FROM
  2. (
  3.     SELECT e.Id, CONCAT(e.FirstName, ' ', e.LastName) AS Name,
  4.            COUNT(r.UserId) AS [Users Number]
  5.       FROM Employees AS e
  6.       LEFT JOIN Reports AS r ON e.Id = r.EmployeeId
  7.     GROUP BY e.Id, e.FirstName, e.LastName, r.UserId
  8. ) AS t
  9. GROUP BY Id, Name
  10. ORDER BY SUM([Users Number]) DESC, Name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement