> SELECT COUNT(1) AS BEER, (SELECT COUNT(1) FROM statuses WHERE account_id=1) AS total FROM statuses WHERE account_id=1 AND text LIKE '%ビール%'; beer | total
------+-------
130 | 18380
(1 row)
ビールはたったの0.7%。たいしたことないねー