Average Child Row Count
Given two tables with a parent-child relationship through a foreign key, is there a way to get the average number of children per parent? I know about the AVG function, but that doesn't seem to apply here, since it only averages column values (not row counts), and only in a single table.