Pergunta de entrevista da empresa Cardinal Health

Some SQL question regarding joins