Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

SQL for Smart Meter Averages

Hard
SQL & Data ManipulationWindow FunctionsDate FunctionsAggregationsAsked 1 times

Problem

Given a database of smart meter readings with irregular timestamps, write a query to find the average hourly consumption per user.

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
Duke Energy Interview Questions
Next questions
SQL for Monthly Electricity AveragesEasyCon EdisonSQL Monthly Electricity AveragesEasyEDFRolling 7-Day Average Per Smart MeterHard
0 / ~200 words