Can you write a SQL query to find the average consumption of electricity by month?
Use the electricity_consumption table and include all available readings. Null consumption values should not contribute to the average.
consumption_month and average_consumption_kwh| Column | Type | Description |
|---|---|---|
| reading_idPK | INT | Unique identifier for the electricity reading |
| reading_date | DATE | Date on which electricity consumption was recorded |
| consumption_kwh | DECIMAL(12,2) | Electricity consumption measured in kilowatt-hours |