Cohere Health Interview Question

1. What are the window functions? 2. Difference between having and where?