Tag favour scale

0

Please login or register to vote for this query.

(click on this box to dismiss)

Data Science

Q&A for Data science professionals, Machine Learning specialists, and those interested in learning more about the field

create Table #TopTags (name VARCHAR(35), amount Int);
create Table #TagScores (name VARCHAR(250), score Int, weight Int);
/*
insert into #TopTags 
select TOP 10000 TagName, Count from Tags order by Count
*/
insert into #TagScores
select Tags, sum(Score), count(*)
from Posts
where Posts.PostTypeId = 1
group by Tags

select * from #TagScores
order by score

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results