Q&A about the site for software quality control experts, automation engineers, and software testers
WITH Questions AS ( SELECT *, case when AcceptedAnswerId > 0 then 'Yes' else 'No' end as 'answer_accepted' FROM Posts WHERE PostTypeId = 1 AND ((LOWER(Tags) LIKE '%<' + 'google-apps-marketplace' + '>%') OR (LOWER(Tags) LIKE '%<' + 'google-workspace-add-ons' + '>%')) AND (CreationDate > DATEADD(day,-300,GETDATE())) ) SELECT COUNT(*) AS number_of_questions, answer_accepted FROM Questions q GROUP BY answer_accepted