Welcome to your interview.
The question is on your right: SQL Window Functions for Market Trends. Take a moment with it first.
Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.
How would you use SQL window functions to calculate rolling averages, rank markets by daily price, and compare each day to the previous day?