0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

--select top 10* from Posts

--Top 10 posts tagged with python

/*select top 10 p.Id,SUM(Score),u.Id,Tags, Reputation,COUNT(p.ID) from Posts p
inner join Users u on p.OwnerUserId  = u.Id
where lower(Tags) like '%python%'
GROUP BY u.Id, p.Id,Tags, Reputation
ORDER BY Score desc;*/


Select top 10 u.Id, COUNT(p.Id) as post_count from Posts p
inner join Users u on p.OwnerUserId  = u.Id
where lower(Tags) like '%python%'
GROUP BY u.Id,Score
ORDER BY Score desc;

fork query

edited may 23

created may 23 anonymous