sql server - Generalize SQL query to include data for all Users -

this popular data.stackexchange.com query allows me query tags of user combined upvotes.

e.g. user 22656 follwing outputed:

tagname, upvotes c#, 147346 java, 84373 .net, 49952 

i extract information (or large subset of) users. can me generalize query?

example output be:

user1, {"taga": 6, "tagb": 4, ...} user2, {"tagx": 7, "tagy": 3, ...} ... usern, {"tagb": 3, "taga": 1, ...} 

select posts.owneruserid,        tagname,        count(*) upvotes  tags     inner join posttags on posttags.tagid = tags.id     inner join posts on posts.parentid = posttags.postid     inner join votes on votes.postid = posts.id , votetypeid = 2 group posts.owneruserid, tagname  order upvotes desc