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