Freudenberg Group interview question

Its so simple sql joins questions