Problem
How would you design a SQL query using window functions to compute rolling metrics and rank entities within each partition?
Practicing as: Data Scientist interview at Citadel SecuritiesHi, I'll play your Citadel Securities interviewer for the Data Scientist role. Candidates describe these interviews as mixed and hard, so expect me to be structured and detail-hungry. Take your time with the question above and answer like we're in the room.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.
