CVS Health interview question

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