Dentsu interview question

A practical solution for a Joins based problem