Zendesk interview question

There was 1 question to write a subquery