Elevance Health interview question

SQL Join statements, indexing, window functions, CTE