SELECT surname AS Nom, firstname AS Prenom, dateofbirth AS Date_naissance, count( borrowernumber ) AS Nbr_comptes FROM borrowers GROUP BY surname, firstname, dateofbirth HAVING COUNT( borrowernumber ) >1
Application : Tout type détablissement
Proposé par : Aix-Marseille Université