My Question: For each keeper, show the number of cages cleaned by the keeper, show the average number of animals in the cages and the total cost of the cages cleaned by the keeper.
TABLES:
========
KEEPER: keeperid, role ('C' for cleaner)
CAGE: cageno, keeperid, cagecost
ANIMAL: animalid, cageno, keeperid
