One side effect of adding 'inform' events into the CotC database is
that it's now directly aware of the identities of defendants. Thus:
select p.name, count(*)
from matters m
join events e on m.id = e.matter
join players p on e.player = p.id
where m.typecode = 'Criminal'
and e.typecode = 'inform'
group by p.name
order by count(*) desc, p.name;
name | count
-----------------------+-------
BobTHJ | 6
comex | 5
Zefram | 4
Goethe | 3
pikhq | 3
root | 3
Eris | 2
Peekee | 2
Murphy | 1
Pineapple Partnership | 1
woggle | 1
(11 rows)
