Cardinal Health Interview Question

Some SQL question regarding joins