Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rolling Average with Window Functions

Hard
HardSQL & Data ManipulationWindow FunctionsDate FunctionsRunning TotalsAsked 1 times

Problem

Given a table of manufacturing sensor logs at Micron Technology, write a query using window functions to calculate the rolling average of machine temperatures over a 3-hour window.

Practicing as: Data Engineer interview at Micron Technology

Hi, I'll play your Micron Technology interviewer for the Data Engineer role. Candidates describe these interviews as mostly positive and moderately difficult, so expect me to be friendly and conversational. Take your time with the question above and answer like we're in the room.

Take this as a live interview session →

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
Micron Technology Data Engineer Interview Questions
Next questions
Micron Memory Malaysia Sdn BhdRolling Average for Machine LogsHardCogniteSQL Rolling Average WindowMediumImpact Recruitment GroupRolling Average with Window FunctionsMedium