SELECT TOP (50) account_id, reputation = SUM(reputation),...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

SELECT TOP (50) 
       account_id, 
       reputation = SUM(reputation),
      count(*) [sites]
     , sum(question_count) [questions]
     , sum(answer_count) [answers]
     , min(s.site_id)
from sede_users u
inner join sede_sites s on s.site_id = u.site_id
group by account_id
order by reputation desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results