Domanda di colloquio di Oracle

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