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 grandchildren GROUP BY grandparent_id, parent_id;
  SELECT child_id, child_first, child_last FROM grandchildren;