Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Window Functions for Anomaly Streaks

Hard
HardSQL & Data ManipulationWindow FunctionsDate FunctionsAggregations
Asked 2mo ago|
GE Aerospace
GE Aerospace
Asked 1 times

Problem

Write a complex SQL query using window functions to identify consecutive days of sensor anomalies.

Practicing as: Data Engineer interview at GE Aerospace

Hi, I'll play your GE Aerospace 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
GE Aerospace Data Engineer Interview QuestionsGE Aerospace Interview Questions
Next questions
AmazonAnomaly Detection With Window FunctionsMediumMacnica AmericasWindow Functions for Anomaly PatternsHardOak Ridge National LaboratorySQL Time-Series Anomaly DetectionMedium