ServiceTitan Interview Question

Asked how to write a nested query