Words in commit messages
edit
mysql> select cr_author, count(cr_author) as num from code_rev where cr_message like '%sucks%' group by cr_author order by num desc;
+------------+-----+
| cr_author | num |
+------------+-----+
| brion | 10 |
| mark | 2 |
| david | 2 |
| catrope | 2 |
| simetrical | 2 |
| demon | 2 |
| valhallasw | 2 |
| vibber | 1 |
| midom | 1 |
| kim | 1 |
| werdna | 1 |
| rainman | 1 |
| dale | 1 |
| overlordq | 1 |
| reedy | 1 |
| btongminh | 1 |
+------------+-----+
16 rows in set (4.87 sec)
mysql> select cr_author, count(cr_author) as num from code_rev where cr_message like '%fuck%' group by cr_author order by num desc;
+-------------+-----+
| cr_author | num |
+-------------+-----+
| aaron | 22 |
| robchurch | 5 |
| brion | 4 |
| david | 4 |
| avar | 3 |
| siebrand | 2 |
| markbergsma | 1 |
| vibber | 1 |
| nickj | 1 |
| daniel | 1 |
| nicdumz | 1 |
+-------------+-----+