PPL Interview Question

SQL Queries with the difficulties