Number of columnc posts with !1 in

select count(*) as Posts, Name from columnc where comment like '%!1%' group by Name order by Posts desc

Posts Name
14 Rich
6 t
4 Jonn
1 Probably Rich
1 Ant
1 Mr. Happy
1 Sam