Water Meters Over the Monthly Cap

Problem

Table: `Meters`

```text
+-------------+------+
| Column Name | Type |
+-------------+------+
| meter_id | int |
| monthly_cap | int |
+-------------+------+
meter_id is the primary key for this table.
Each row gives the allowed monthly water volume (in litres) for a meter.
```

Table: `Readings`

```text
+-------------+----------+
| Column Name | Type |
+-------------+----------+
| reading_id | int |
| meter_id | int |
| flow_type | enum |
| volume | int |
| read_day | datetime |
+-------------+----------+
reading_id is the primary key for this table.
flow_type is an ENUM of ('Usage', 'Credit'). Only 'Usage' counts toward consumption; 'Credit' rows are refunds and must be ignored.
```

A water meter is flagged as over-cap if its total monthly 'Usage' volume exceeds its monthly_cap in two or more consecutive calendar months.

Write a solution to report the `meter_id` of all over-cap meters.

Return the result table in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns meter_id.

Starter code (SQL)

SELECT *
FROM Meters;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium