Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rolling 30-Day Default Rate SQL

Hard
SQL & Data ManipulationWindow FunctionsDate FunctionsRunning Totals
Asked 2mo ago|
Koalafi
Koalafi

Problem

Write a SQL query using window functions to calculate each Koalafi customer's rolling 30-day default rate by month.

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Koalafi Data Scientist Interview QuestionsKoalafi Interview Questions
Next questions
NaviRolling 30-Day Default RateHardT Mobile UsRolling 30-Day Default RateHardForward FinancingRolling Cohort Default Rate SQLHard
0 / ~200 words