select account_id , sum(reputation) [total rep] , count(*...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Earth Science

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

select account_id
     , sum(reputation) [total rep]
     , count(*) [# sites]
     , sum(question_count) [# questions]
     , sum(answer_count) [# answers]
     , min(d.database_name) [db]
from sede_users u
inner join sede_sites s on s.site_id = u.site_id
inner join sede_databases d on d.database_name = s.database_name
where d.site_type = 'main_site'
group by account_id
having sum(reputation) > 9000
order by sum(reputation) desc


select u.account_id
     , s.*
     , d.database_name
     , d.site_type
from sede_users u
inner join sede_sites s on s.site_id = u.site_id
inner join sede_databases d on d.database_name = s.database_name
where account_id = 11683

Enter Parameters

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