0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

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,-30,GETDATE()))
  )

SELECT 
  COUNT(*) AS number_of_questions,
  answer_accepted
FROM Questions q
GROUP BY answer_accepted

fork query

edited oct 4 jon.doe45927

created mar 7 dynamicwebpaige