CVS Health Interview Question

MySql, join, windows, where, having