CVS Health interview question

SQL: difference between WHERE and HAVING; windows function