SELECT *
FROM president
WHERE pres_name IN (SELECT p.pres_name
                    FROM president p,pres_marriage m
                    WHERE p.pres_name = m.pres_name
                    AND party = 'Republican'
                    GROUP BY p.pres_name
                    HAVING SUM(nr_children) >= ALL (SELECT SUM(nr_children)
                                                    FROM president p,pres_marriage m
                                                    WHERE p.pres_name = m.pres_name AND
                                                            party = 'Republican'
                                                    GROUP BY p.pres_name))