PPL interview question

SQL Queries with the difficulties