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 like 'postgresql%')
and t.TagName in ('java', 'c#', 'python', 'perl', 
                  'javascript', 'c', 'c++', '.net', 
                  'ruby', 'scala', 'kotlin')  
group by t.TagName
order by count(*) desc

fork query

edited nov 23 anonymous

created aug 26 20 jon.doe32522