Pregunta de entrevista de Office Practicum

Write an SQL query that solves X problem.