Interview Questions
Interview Guides
Experiences
Explore
Get started
Sign in
Interview Guides
All questions
/
SQL & Data Manipulation
Rolling 7-Day Dropped Calls
Medium
Asked at 1 company
Window Functions
Date Functions
Running Totals
Problem
Write a query to calculate the rolling 7-day average of dropped calls per agent for Aircall.
Question
Answer
Problem
Write a query to calculate the rolling 7-day average of dropped calls per agent for Aircall.
Your answer
Edit
Preview
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.
0 words
target ~200
Try a free preview
Stuck? Get a hint
Past attempts
Up next
Rolling 7-Day Average SQL
Medium
Rolling Average Over 7 Days
Hard
Rolling 7-Day Average by Region
Medium
Next question
Rolling 7-Day Dropped Calls | Dataford Interview Questions
![[24]7.ai](/_next/image?url=https%3A%2F%2Fstorage.googleapis.com%2Fcompany-logos-bucket%2Flogos%2F247ai.png&w=3840&q=75)
