0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

select t.TagName, 
       count(*) as num_questions
from PostTags pt
  join Tags t on t.Id = pt.TagId
where pt.PostId in (select p.Id
                    from Posts p
                      join PostTags pt2 on pt2.PostId = p.Id
                      join Tags t2 on t2.Id = pt2.TagId
                    where t2.TagName = 'postgresql')
and t.TagName in ('java', 'c#', 'python', 'perl', 'javascript')  
group by t.TagName

view current version

edited aug 26 20

created aug 26 20 jon.doe32522