Q&A for professional and enthusiast programmers
select count(*) N, round(avg(Score*1.0), 2) avg_score, isnull(Location, '') location from Users u join Posts on OwnerUserId = u.Id where PostTypeId = 1 group by isnull(Location, '') order by count(*) desc