Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
;with top_answerers as (
, sum(a.score) [tag score]
, rank() over(partition by t.tagname order by sum(a.score) desc ) as pos
from posts a
inner join posts q on q.id = a.parentid
inner join posttags pt on pt.postid = q.id
inner join tags t on t.id = pt.tagid
where a.posttypeid = 2 -- answer
and q.posttypeid = 1 -- Question
and a.owneruserid is not null
group by a.owneruserid
having sum(a.score) > 10
, owneruserid as [User Link]
, [tag score]
where -- owneruserid = ##userid?7031230##
tagname = 'ssis'
and pos <10
where sourcetagname like'%ssis%'
or targettagname like'%ssis%'
where tagname like '%ssis%'