Aviso Interview Question

Query for finding duplicated records