Q&A for GenAI enthusiasts and practitioners and those interested in learning more about using GenAI tools
-- questions + views for tags on serverfault -- Enter Query Description -- find number of questions for a list of tags -- given a list of tags find out how many question each of the tags has select Tags.Tagname, count(Posts.Id) as questions, sum(ViewCount) as views from Posts left join PostTags on PostS.Id = PostTags.PostId left Join Tags on PostTags.TagId = Tags.Id where Tags.TagName in ( -- enter tags here 'Asterisk','Asterisknow','Voip','SIP','PBX','Trixbox','Telephony','Freepbx','Pbxt','Telephony','SMS','SSMS2008','SMS-Gateway','agi','ivr','tts','fastagi','adhearsion','twilio','tropo','telephony','kannel','smpp' ) group by Tags.TagName