select top 10 p.Id,SUM(Score),u.Id,Tags, Reputation fro...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

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 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,  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;*/

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results