Questions by high answerers..

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

select top 200 p.id as [Post Link], p.score, p.viewcount, p.answercount, p.tags,
  u.reputation, u.id as [User Link]
from posts p
inner join users u on p.owneruserid = u.id
cross apply (
  select count(*) as value
    from posts
    where owneruserid = u.id
      and posttypeid = 2
) answers
cross apply (
  select count(*) as value
    from posts
    where owneruserid = u.id
      and posttypeid = 1
) questions
where u.reputation >= 1000
  and p.tags like '%python%'
  and answers.value > questions.value
  and p.creationdate > '2019-12-01'
order by p.creationdate desc

Enter Parameters

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