select t.tagname , count(*) as answers , sum(case when a...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

select t.tagname
     ,  count(*) as answers
     , sum(case when a.id = q.acceptedanswerid then 1 else 0 end) as accepts
     , sum(case when a.id = q.acceptedanswerid then 1 else 0 end) / cast(count(*) as decimal) acceptrate
from posts q 
inner join posts a on a.parentid = q.id
inner join posttags pt on pt.postid = q.id
inner join tags t on t.id = pt.tagid
where t.tagname in ('surface-duo')
and q.CreationDate between '2020-01-01' and '2020-10-21'
group by t.tagname
order by count(*) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results