CREATE TABLE foobar ( Who CHAR(1), When DATETIME);
...
INSERT INTO foobar ...
INSERT INTO foobar ...
...
SELECT Who, COUNT(DISTINCT who) FROM foobar GROUP BY who;
...