SQL Average Consumption By Region | Dataford Interview Questions

Write a SQL query to find the average energy consumption by region for TotalEnergies.

Use the energy consumption table and exclude records with a missing region or consumption value.

Output

Do not restrict the calculation to TotalEnergies records; average all rows in the energy consumption table.
Include zero and negative consumption values in the average.
Return the exact unrounded average, preserving the full numeric precision shown by the source values.

energy_consumption

Column	Type	Description
consumption_idPK	INT	Unique energy consumption record identifier
region	VARCHAR(100)	Geographic region associated with the measurement
consumption	DECIMAL(12,2)	Energy consumption measurement

Your question is SQL Average Consumption By Region. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Write a SQL query to find the average energy consumption by region for TotalEnergies.

Use the energy consumption table and exclude records with a missing region or consumption value.

Do not restrict the calculation to TotalEnergies records; average all rows in the energy consumption table.
Include zero and negative consumption values in the average.
Return the exact unrounded average, preserving the full numeric precision shown by the source values.

energy_consumption

Column	Type	Description
consumption_idPK	INT	Unique energy consumption record identifier
region	VARCHAR(100)	Geographic region associated with the measurement
consumption	DECIMAL(12,2)	Energy consumption measurement

Your question is SQL Average Consumption By Region. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.