CVS Health interview question

MySql, join, windows, where, having