Q&A for Ubuntu users and developers
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 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