Proofpoint Interview Question

simple SQL join query to solve