How can we group this query only by USER?

Transact-SQL
4

For reference, it looks like this thread is continued from this.