select u.DisplayName, u.id, u.Location, u.Reputation, c...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Patents Meta

Q&A about the site for people interested in improving and participating in the patent system

-- Find answers of a user tagged by a specific tag
-- This query is useful for converting a user's answers from tag A to tag B


select u.DisplayName, u.id, u.Location, u.Reputation, count(distinct b.Name) as 'Badge Count'
from Users u 
join Badges b on b.UserId = u.id 
where Reputation  >= 550000
group by u.DisplayName, u.id, u.Location, u.Reputation
order by 5 desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results