1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  EOMONTH(CreationDate) AS CreationMonth,
  CASE
    WHEN Tags LIKE '%<kotlin>%' AND
      Tags LIKE '%<java>%' THEN 'android & kotlin & java'
    WHEN Tags LIKE '%<kotlin>%' THEN 'android & kotlin'
    WHEN Tags LIKE '%<java>%' THEN 'android & java'
  END AS TagGroup,
  COUNT(*) AS group_count
FROM Posts
WHERE (Tags LIKE '%<android>%'
AND Tags LIKE '%<kotlin>%')
OR (Tags LIKE '%<android>%'
AND Tags LIKE '%<java>%')
GROUP BY EOMONTH(CreationDate),
         CASE
           WHEN Tags LIKE '%<kotlin>%' AND
             Tags LIKE '%<java>%' THEN 'android & kotlin & java'
           WHEN Tags LIKE '%<kotlin>%' THEN 'android & kotlin'
           WHEN Tags LIKE '%<java>%' THEN 'android & java'
         END
ORDER BY EOMONTH(CreationDate)

fork query

edited sep 14 22

created sep 14 22 Abdul.Aziz.Barkat