CVS Health Interview Question

The models used for optimising the pipeline? Detailed SQL advanced Question