Question d’entretien chez HackerRank

Writing a SQL query for some problem that I don't remember