Here is the SQL query that you can use to get the desired result:

```sql
SELECT m.meter_number
FROM meter m
JOIN bill b ON m.meter_id = b.meter_id
GROUP BY m.meter_number
HAVING SUM(b.total_units) = (
SELECT MIN(total_units_sum)
FROM (
SELECT SUM(b.total_units) as total_units_sum
FROM meter m
JOIN bill b ON m.meter_id = b.meter_id
GROUP BY m.meter_number
) as subquery
)
ORDER BY m.meter_number ASC;
```

Here is the step by step explanation of the query:

1. We join the `meter` and `bill` tables on `meter_id`.
2. We group the results by `meter_number`.
3. We use the `HAVING` clause to filter the groups by the condition that the sum of `total_units` for the group is equal to the minimum sum of `total_units` across all groups. This minimum sum is calculated in a subquery.
4. Finally, we order the results by `meter_number` in ascending order.

Question

Here is the SQL query that you can use to get the desired result:

```sql
SELECT m.meter_number
FROM meter m
JOIN bill b ON m.meter_id = b.meter_id
GROUP BY m.meter_number
HAVING SUM(b.total_units) = (
    SELECT MIN(total_units_sum)
    FROM (
        SELECT SUM(b.total_units) as total_units_sum
        FROM meter m
        JOIN bill b ON m.meter_id = b.meter_id
        GROUP BY m.meter_number
    ) as subquery
)
ORDER BY m.meter_number ASC;
```

Here is the step by step explanation of the query:

1. We join the `meter` and `bill` tables on `meter_id`.
2. We group the results by `meter_number`.
3. We use the `HAVING` clause to filter the groups by the condition that the sum of `total_units` for the group is equal to the minimum sum of `total_units` across all groups. This minimum sum is calculated in a subquery.
4. Finally, we order the results by `meter_number` in ascending order.

Knowee AI · Accepted Answer

Here is the SQL query that you can use to get the desired result:

```sql
SELECT m.meter_number
FROM meter m
JOIN bill b ON m.meter_id = b.meter_id
GROUP BY m.meter_number
HAVING SUM(b.total_units) = (
    SELECT MIN(total_units_sum)
    FROM (
        SELECT SUM(b.total_units) as total_units_sum
        FROM meter m
        JOIN bill b ON m.meter_id = b.meter_id
        GROUP BY m.meter_number
    ) as subquery
)
ORDER BY m.meter_number ASC;
```

Here is the step by step explanation of the query:

1. We join the `meter` and `bill` tables on `meter_id`.
2. We group the results by `meter_number`.
3. We use the `HAVING` clause to filter the groups by the condition that the sum of `total_units` for the group is equal to the minimum sum of `total_units` across all groups. This minimum sum is calculated in a subquery.
4. Finally, we order the results by `meter_number` in ascending order.

Question

Solution

Similar Questions

Upgrade your grade with Knowee