CVS Health interview question

SQL join problem; Why this company; Sort problem.