Q&A for entrepreneurs faced with delivering a new product or service under conditions of significant uncertainty
select ans.OwnerUserId as [User Link],
cast(acc_cnt as float)/ans_cnt as pct_acc
count(*) as ans_cnt
where CreationDate > '2017-01-01'
and PostTypeId = 2
Group by OwnerUserId) as ans
count(*) as acc_cnt
from Posts as a
Posts as b
ON a.AcceptedAnswerId = b.Id
where a.CreationDate > '2017-01-01'
Group by b.OwnerUserId) as acc
ON ans.OwnerUserId = acc.OwnerUserId
--where ans_cnt > 100
order by pct_acc desc, ans_cnt desc