Percentage of posts deleted by date by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT
  CONVERT(DATE, DeletionDate) as [Deletion date],
  100.0 * SUM(CASE WHEN Tags LIKE '%<##TagName1?android##>%' THEN 1 ELSE 0 END) / COUNT(*) as [% ##TagName1##],
  100.0 * SUM(CASE WHEN Tags LIKE '%<##TagName2?javascript##>%' THEN 1 ELSE 0 END) / COUNT(*) as [% ##TagName2##],
  100.0 * SUM(CASE WHEN Tags LIKE '%<##TagName3?php##>%' THEN 1 ELSE 0 END) / COUNT(*) as [% for ##TagName3##],
  100.0 * SUM(CASE WHEN Tags LIKE '%<##TagName4?sql##>%' THEN 1 ELSE 0 END) / COUNT(*) as [% for ##TagName4##],
  100.0 * SUM(CASE WHEN Tags LIKE '%<##TagName5?python##>%' THEN 1 ELSE 0 END) / COUNT(*) as [% for ##TagName5##],
  100.0 * SUM(CASE WHEN Tags LIKE '%<##TagName6?java##>%' THEN 1 ELSE 0 END) / COUNT(*) as [% for ##TagName6##]
FROM
  PostsWithDeleted
WHERE
  DeletionDate >= ##Since:String?2021-01-01##
GROUP BY CONVERT(DATE, DeletionDate)
ORDER BY CONVERT(DATE, DeletionDate) ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results