Cardinal Health interview question

Some SQL question regarding joins