Q&A for ebook publishers and readers
SELECT COUNT(*) AS TotalQuestions, COUNT(CASE WHEN AcceptedAnswerId IS NOT NULL THEN 1 END) AS QuestionsWithAcceptedAnswers FROM Posts q WHERE q.PostTypeId = 1 -- 1 indicates questions AND q.CreationDate >= '2022-01-01' AND q.ClosedDate IS NULL -- Exclude closed questions AND q.Id IN ( SELECT PostId FROM PostTags WHERE TagId = (SELECT Id FROM Tags WHERE TagName = 'activemq-classic') )