SELECT COUNT(body)
FROM comment
WHERE body LIKE '%[deleted]%';

SELECT COUNT(c1.body)
FROM comment c1, comment c2
WHERE c1.body LIKE '%[deleted]%';