Q&A about the site for finance professionals and academics
Select count(*) as Post_count FROM Posts p WHERE p.id in ( select pt.PostId from PostTags pt inner join Posts p on pt.PostId = p.Id inner join Tags t on pt.TagId = t.Id where p.Id in (SELECT pt.PostId from PostTags pt WHERE pt.TagId=16) and p.Id in (SELECT pt.PostId from PostTags pt WHERE pt.TagId=67145) GROUP BY p.title, pt.PostId) AND p.creationdate between '2016/01/01' and '2023/01/01' --Select * From tags Where TagName in('cpp'); -- 75599 Kotlin -- 17 Java -- 1386 Android -- 115695 flutter -- 9 c# -- 80035 xamarin -- python 16 --js 3 -- react 110853 -- kivy 67145 -- buildozer 111535 -- c++ 10