Office Practicum interview question

Write an SQL query that solves X problem.