Programming languages used with Postgres

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results