Q&A for programming puzzle enthusiasts and code golfers
with questions_asked as ( select OwnerUserId, case when Score < 0 then 1 else 0 end negative, case when ClosedDate is not null then 1 else 0 end closed, 1.0 total from Posts where OwnerUserId in (##UseIds##) and PostTypeId = 1 ) select OwnerUserId as [User Link], sum(negative) negative, sum(closed) closed, sum(total) total, (sum(total) - sum(negative) - sum(closed))/sum(total) asking_record from questions_asked group by OwnerUserId