Q&A for professional and enthusiast programmers
select top(15) p.id,p2.id as "answer_id",p.AcceptedAnswerId as "accepted_id",
p.CreationDate as "question_created",p2.CreationDate as "answer_created",
p.score as "question_score",p2.score as "answer_score",
p.body as "question_body",p2.body as "answer_body" from posts as p
join posts as p2 on p2.parentid = p.id
where p2.id in (
select top(3) id
where posttypeid = 2 and parentid = p.id
order by score desc
and p.title like '%language%process%'
and p.tags like '%python%'
order by p.id asc, p2.score desc;