or download this
SELECT distinct parent_id FROM grandchildren;
SELECT grandparent_id, count(distinct parent_id) FROM grandchildren
+GROUP BY grandparent_id;
SELECT grandparent_id, parent_id, count(*) as num_kids FROM grandchi
+ldren GROUP BY grandparent_id, parent_id;
SELECT child_id, child_first, child_last FROM grandchildren;