0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professionals and students of engineering

select  
t.TagName as 'Skill',
--vt.Id as 'VoteCode',
--vt.Name as 'VoteType',
us.Reputation as 'Creator Reputation',
SUM(CONVERT(bigint, ps.ViewCount)) AS 'ViewCount',
sum(ps.Score) AS 'PostScore',
count(*) as 'CountPost'
from Posts ps,PostTags pt, Tags t,Votes v,VoteTypes vt,Users us
where 
ps.Id=pt.PostId
and ps.OwnerUserId=us.Id
and pt.TagId=t.Id 
and v.PostId=Ps.Id
and v.VoteTypeId=vt.Id
and t.TagName in ('contact'
,'replication'
,'bank'
,'summary'
,'reporting'
,'nuance'
,'hive'
,'informatica'
,'sql'
,'leader'
,'etl'
,'database'
,'key'
,'areas'
,'master'
,'cloudera'
,'scrum'
,'designer'
,'status'
,'p'
,'face'
,'phase'
,'financial'
,'kibana'
,'del'
,'projects'
,'touch'
,'logic'
,'system'
,'hdfs'
,'operational'
,'java'
,'attunity'
,'navigator'
,'addition'
,'get'
,'coordinate'
,'hue'
,'e'
,'profiling'
,'requirement'
,'role'
,'project'
,'dedicated'
,'datamart'
,'loading'
,'repository'
,'sip'
,'range'
,'principal'
,'linkedin'
,'position'
,'el'
,'cobertura'
,'lead'
,'streamsets'
,'store')
group by t.TagName,us.Reputation--,vt.Id,vt.Name
order by t.TagName desc

fork query

edited mar 22 18 anonymous

created mar 20 18 Mohsin