Office Practicum Interview Question

Write an SQL query that solves X problem.