with t as (select q.id as questions, count(*) num from po...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Patents Meta

Q&A about the site for people interested in improving and participating in the patent system

with t as 
(select q.id as questions, count(*) num
from posts q join posts a on q.id=a.parentid
where a.score>2 and year(q.creationdate)=2019
group by q.id)

select * from t where num=(select max(num) from t)

Enter Parameters

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