Federato interview question

SQL question with double joins. DS&A easy question.