Q&A about the site for biology researchers, academics, and students
SELECT COUNT(*) AS TotalQuestions, COUNT(CASE WHEN AcceptedAnswerId IS NOT NULL THEN 1 END) AS QuestionsWithAcceptedAnswers FROM Posts WHERE PostTypeId = 1 -- 1 indicates questions AND CreationDate >= '2022-01-01' AND Id IN ( SELECT PostId FROM PostTags WHERE TagId = (SELECT Id FROM Tags WHERE TagName = 'activemq-classic') )