Highest Consumption Month per Meter

Using the Consumption table, return each meter and the month with its highest kWh. Order by meter.

Table schema

Consumption(meter_id INT, month CHAR(7), kwh INT)

Sample data

Consumption
meter_id | month | kwh
1 | 2026-02 | 120
1 | 2026-03 | 60
2 | 2026-02 | 60
2 | 2026-03 | 90
3 | 2026-03 | 250