Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Window Functions for Anomaly Patterns

Hard
HardSQL & Data ManipulationWindow FunctionsDate FunctionsRankingAsked 1 times

Problem

Write a SQL query using window functions to identify the top three repeating data anomalies by category over the last quarter for Macnica Americas.

Practicing as: Data Analyst interview at Macnica Americas

Hi, I'll play your Macnica Americas interviewer for the Data Analyst role. Answer the question above like we're in the room, and I'll respond the way a real interviewer would.

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
Macnica Americas Interview QuestionsMacnica Americas Data Analyst Interview Questions
Next questions
GE AerospaceWindow Functions for Anomaly StreaksHardAmazonAnomaly Detection With Window FunctionsMediumOak Ridge National LaboratorySQL Time-Series Anomaly DetectionMedium