It looks something like the following: SELECT b.Id, COUNT(DISTINCT a.UserId ... is basically a pointer to the row number of the results. To do this in MS SQL Server, add the following to the ...

SELECT options refine results As we saw in the last article, the SQL SELECT ... last_name; DISTINCT returns unique results The DISTINCT keyword returns only unique rows within a result set.