CVS Health Interview Question

Asked several DB queries that require usage of analytical functions like range, dense.