Top C Devs in Greece

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select u.id id, count(a.id) answerCount into #SelectedUsers from posts a
join users u on u.id = a.owneruserid
join posts q on a.parentid = q.id
where a.posttypeid = 2 and q.tags like '%C++%' and u.location like '%Greece%'
group by u.id
select u.AccountId, u.id, u.Reputation, u.DisplayName, u.Location, u.UpVotes, u.DownVotes,su.answerCount
from users u join #SelectedUsers su on su.id = u.id
where u.Reputation > 100
order by Reputation desc

Enter Parameters

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