Q&A about the site for people who use Blender to create 3D graphics, animations, or games
WITH Questions AS ( SELECT * FROM Posts WHERE PostTypeId = 1 ) SELECT COUNT(*) AS number_of_questions, (q.AcceptedAnswerId) AS answer_accepted FROM Questions q WHERE ((LOWER(Tags) LIKE '%<' + 'google-apps-marketplace' + '>%') OR (LOWER(Tags) LIKE '%<' + 'google-workspace-add-ons' + '>%')) AND (CreationDate > DATEADD(day,-30,GETDATE())) GROUP BY q.AcceptedAnswerId