Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rolling 7-Day Robot Uptime

Hard
SQL & Data ManipulationWindow FunctionsDate FunctionsRunning Totals

Problem

Given a table of robot telemetry logs and a table of maintenance events, calculate the rolling 7-day average of robot uptime at Foundation Robotics Labs.

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
Foundation Robotics Labs Data Analyst Interview Questions
Next questions
Amazon RoboticsRolling 7-Day Error AverageMediumAmazon Robotics7-Day Rolling Failure Rate SQLHard[24]7.aiRolling 7-Day Average SQLMedium
0 / ~200 words