CODE EXAMPLE FOR SQL

sql sum of same record

SELECT Pres_name,
   SUM(Nr_children) AS nr_cnt
FROM PRES_MARRIAGE
GROUP BY Pres_name;