Request for aggregate data regarding deleted questions with subjects containing CORRECT, GRAMMA, or RIGHT

Question

This support request will require the assistance of a Stack Exchange employee, probably a kindly Community Manager.

As shown at the bottom of this answer, I present some SEDE results on just how many non-deleted questions’ titles contain any of “correct”, “gramma”, or “right”. I used queries like these to produce those charts:

1. Closed Questions matching CORRECT/GRAMMA/RIGHT
2. Open Questions matching CORRECT/GRAMMA/RIGHT

Those allow one to produce a chart like this:

               Closed   Open  Cl/Op%
               ------  ------ ------
1. CORRECT       675    1577     43%
2. GRAMMA        202     515     39%
3. RIGHT          91     293     31%
4. Any           867    2165     40%

However, those figures are quite wrong because they do not contain deleted questions matching those strings.

My specific support request is for a kindly Community Manager¹ to please run a version of the closed query against their own private version of SEDE which actually includes the deleted data as well, and then tell us how many they found.

To make it easier, it would be enough just to report back the number of DELETED questions matching any of those strings. With just the result of that single modified query run against the employee-only info, we will be able to fill in the Deleted column’s ??? figure here:

               Deleted  Closed   Open  Cl/Op%
               ------- ------  ------ ------
4. Any           ?????    867    2165     40%

This will allow the ELU community to more realistically consider the potential ramifications of adding those as blacklisted keywords.

Perhaps only “correct” and “gramma’ are what we should end up blacklisting, but we really need to understand the deleted questions first before we can really even discuss this further.

Any other guidance you may wish to give us on this would also be much appreciated.

---

Footnote

1. If no kindly Community Manager is available, then any other sort will work, too. :)

Answer 1

Including deleted questions:

        Deleted Closed Open Closed% Deleted% Cl or Del% 
        ------- ------ ----  ------ -------- ----------
CORRECT     938   1513 1687     47%      29%        51%
GRAMMA      250    341  333     51%      37%        54%
RIGHT       111     17  294     38%      24%        41%
Any        1299   2031 2314     47%      30%        50%

If a title contains more than one of these keywords, it's only counted once because I used this case statement:

  case 
     when Title like '%correct%' then 'CORRECT'
     when Title like '%gramma%'  then 'GRAMMA'
     when Title like '%right%'   then 'RIGHT'
   end

It's also possible for a question to be deleted and open.

Just for kicks, here's the same query for all questions regardless of title:

Deleted Closed Open  Closed% Deleted% Cl or Del%
------- ------ ----- ------- -------- ----------
  14985  23303 42198     36%      23%        41%

That puts ELU in 6^th place when it comes to close rate. (For the curious, the top 5 are Programmers, The Workplace, Network Engineering, Christianity, and Patents.) When compared to the median close rate of 15% (TeX—LaTeX and DBA), the grammar questions look pretty bad. But compared to this site's close rate, titles like '%right%' are awfully similar to other questions.

Also to be considered is if forbidding problem titles will be sufficient to prevent problem questions.