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 50000
p.id,p.Title,p.Body,p.Tags,p.score,a.id as "Answer ID",
a.body as "Accepted Answer",u.Reputation as "User Reputation"
--,c.Text as "Comment Text",answers.Body as "Answers"
FROM Posts p
--INNER JOIN posts answers ON p.id = answers.ParentId
INNER JOIN Posts a ON p.AcceptedAnswerId = a.Id
INNER JOIN Users u ON p.OwnerUserId = u.Id
--INNER JOIN Comments c ON p.id = c.PostId
WHERE p.PostTypeId = 1
and p.tags like '%python%'
and p.OwnerUserId in
(Select Id from Users where
reputation > ##reputation1## and reputation <=##reputation2##