Programming languages used with Postgres

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフロー

プログラマーとプログラミングに熱心な人々のための質問と回答

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', '.net core', 'kotlin')  
group by t.TagName
order by count(*) desc

Enter Parameters

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