(the extreme self-learners)
プログラマーとプログラミングに熱心な人々のための質問と回答
select top 10 u.Id, u.DisplayName, min(u.Reputation) as Reputation, sum(len(p.Body)) as TotalLength, count(*) as TotalPosts, avg(len(p.Body)) as AvgPostLength, (cast(sum(len(p.Body)) as float) / cast(min(u.Reputation) as float)) as Effort from Posts p inner join Users u ON u.Id = p.OwnerUserId where u.Id = 158779 group by u.Id, u.DisplayName