CVS Health interview question

Basic SQL - Joins, Aggregations, Window/Analytical questions