TransUnion Interview Question

Write an SQL query using JOIN