Eurofins interview question

SQL queries to remove duplicates.