PrognoCIS Interview Question

how to get duplicate name and show how may times it duplicates in sql database