Pregunta de entrevista de CVS Health

SQL join problem; Why this company; Sort problem.