Asking record

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

with questions_asked as (
select OwnerUserId,
case when Score < 0 then 1 end negative,
case when ClosedDate is not null then 1 end closed,
1 total
from Posts
where OwnerUserId in (##UseIds##)
and PostTypeId = 2
)
select OwnerUserId as [User Link],
sum(negative),
sum(closed),
sum(total)
from questions_asked
group by OwnerUserId