Subex Interview Question

SQL query to delete duplicate data in