CVS Health Interview Question

SQL join problem; Why this company; Sort problem.