Wells Fargo interview question

write a join query