Here is a SQL query that should give you the desired result:

```sql
SELECT m.meter_number
FROM meter m
JOIN bill b ON m.meter_id = b.meter_id
WHERE b.fine_amount = (
SELECT MAX(fine_amount)
FROM bill
WHERE MONTH(bill_date) = MONTH(CURRENT_DATE)
AND YEAR(bill_date) = YEAR(CURRENT_DATE)
)
```

This query works as follows:

1. It joins the `meter` and `bill` tables on the `meter_id` field.
2. It then selects the `meter_number` from the `meter` table where the `fine_amount` in the `bill` table is equal to the maximum `fine_amount` for the current month.
3. The subquery in the WHERE clause finds the maximum `fine_amount` for the current month and year.

Please replace `CURRENT_DATE` with the specific month you are interested in if you are not looking for the current month.

Question

Here is a SQL query that should give you the desired result:

```sql
SELECT m.meter_number
FROM meter m
JOIN bill b ON m.meter_id = b.meter_id
WHERE b.fine_amount = (
    SELECT MAX(fine_amount)
    FROM bill
    WHERE MONTH(bill_date) = MONTH(CURRENT_DATE)
    AND YEAR(bill_date) = YEAR(CURRENT_DATE)
)
```

This query works as follows:

1. It joins the `meter` and `bill` tables on the `meter_id` field.
2. It then selects the `meter_number` from the `meter` table where the `fine_amount` in the `bill` table is equal to the maximum `fine_amount` for the current month.
3. The subquery in the WHERE clause finds the maximum `fine_amount` for the current month and year.

Please replace `CURRENT_DATE` with the specific month you are interested in if you are not looking for the current month.

Knowee AI · Accepted Answer

Here is a SQL query that should give you the desired result:

```sql
SELECT m.meter_number
FROM meter m
JOIN bill b ON m.meter_id = b.meter_id
WHERE b.fine_amount = (
    SELECT MAX(fine_amount)
    FROM bill
    WHERE MONTH(bill_date) = MONTH(CURRENT_DATE)
    AND YEAR(bill_date) = YEAR(CURRENT_DATE)
)
```

This query works as follows:

1. It joins the `meter` and `bill` tables on the `meter_id` field.
2. It then selects the `meter_number` from the `meter` table where the `fine_amount` in the `bill` table is equal to the maximum `fine_amount` for the current month.
3. The subquery in the WHERE clause finds the maximum `fine_amount` for the current month and year.

Please replace `CURRENT_DATE` with the specific month you are interested in if you are not looking for the current month.

Question

Solution

Similar Questions

Upgrade your grade with Knowee