Aviso interview question

Query for finding duplicated records