Angular users in Greece

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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 '%aws%'
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,  u.Age
from users u
join #SelectedUsers su on su.id = u.id
where u.Reputation > 100
order by Reputation desc

Enter Parameters

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