Deleted questions by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

SELECT
  '##Tag##' as TagName,
  Deleted as [Deleted questions],
  Total as [Total questions],
  ROUND(CAST(Deleted as float)/CAST(Total as float) * 100, 2) as [Percent deleted]
FROM (
  SELECT
    SUM(case when p.DeletionDate is not null then 1 else 0 end) as Deleted,
    COUNT(*) as Total
  FROM
    PostsWithDeleted p
  WHERE
    p.Tags LIKE '%<' + '##Tag##' + '>%'
) as intermediate

Enter Parameters

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