column-projection.sql

select top 20 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
inner join posts x on x.owneruserid = u.id
where u.reputation >= 1000
  and p.tags like '%python%'
group by p.id, p.score, p.viewcount, p.answercount, p.tags, p.creationdate, u.reputation, u.id
having sum(case when x.posttypeid = 1 then 1 else 0 end)
     < sum(case when x.posttypeid = 2 then 1 else 0 end) 
order by p.creationdate desc