Q&A about the site for users of Iota, the open-source cryptocurrency for IoT that does not use a blockchain
select count(*) as question_count, t.Id from Posts p join PostTags pt on p.Id = pt.PostId join Tags t on pt.TagId = t.id where p.PostTypeId = 1 and t.tagName in ('python', 'java') group by t.Id