CVS Health Interview Question

SQL: difference between WHERE and HAVING; windows function