Question d’entretien chez Oracle

They asked me to solve one medium-level LeetCode problem and write an SQL query.