clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 921174 fiddles created (11942 in the last week).

CREATE TABLE comment ( comment_id serial PRIMARY KEY , body text ); INSERT INTO comment(body) VALUES ('foo') , ('bar [deleted]') , ('not really [deleted') , ('[deleted]') , ('baz [deleted]') ;
5 rows affected
 hidden batch(es)


SELECT round(count(body LIKE '%[deleted]%' OR NULL)::numeric / NULLIF(count(*), 0), 2) AS percent_deleted FROM comment;
percent_deleted
0.60
 hidden batch(es)