Cox Enterprises interview question

Write this sql join to get this data