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

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.

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.