Freudenberg Group Interview Question

Its so simple sql joins questions