Freddie Mac Interview Question

Create a query using tables given, how would you solve to get xyz