Pregunta de entrevista de Sony Pictures Entertainment

How will you query SQL statement in this situation?