Questions by high answerers..

0

Please login or register to vote for this query.

(click on this box to dismiss)

Health Meta

Q&A about the site for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences

select top 200 p.id as [Post Link],
  p.creationdate, 
  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