Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
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=1386) AND p.Id in (SELECT pt.PostId from PostTags pt WHERE pt.TagId=75599) GROUP BY p.title, pt.PostId) AND p.creationdate between '2017/01/01' and '2018/01/01' -- 75599 Kotlin -- 17 Java