CVS Health Interview Question

basic sql problems like to join