Elevance Health Interview Question

SQL Join statements, indexing, window functions, CTE