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

```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;
```

This query works as follows:

1. It joins the `meter` and `bill` tables on the `meter_id` field.
2. It groups the result by `meter_number`.
3. It selects only those groups where the sum of `total_units` is equal to the minimum sum of `total_units` across all groups. This is achieved by using a subquery that calculates the sum of `total_units` for each `meter_number` and then selects the minimum of these sums.
4. Finally, it orders the result by `meter_number` in ascending order.

Question

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

```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;
```

This query works as follows:

1. It joins the `meter` and `bill` tables on the `meter_id` field.
2. It groups the result by `meter_number`.
3. It selects only those groups where the sum of `total_units` is equal to the minimum sum of `total_units` across all groups. This is achieved by using a subquery that calculates the sum of `total_units` for each `meter_number` and then selects the minimum of these sums.
4. Finally, it orders the result by `meter_number` in ascending order.

Knowee AI · Accepted Answer

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

```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;
```

This query works as follows:

1. It joins the `meter` and `bill` tables on the `meter_id` field.
2. It groups the result by `meter_number`.
3. It selects only those groups where the sum of `total_units` is equal to the minimum sum of `total_units` across all groups. This is achieved by using a subquery that calculates the sum of `total_units` for each `meter_number` and then selects the minimum of these sums.
4. Finally, it orders the result by `meter_number` in ascending order.

Question

Solution

Similar Questions

Upgrade your grade with Knowee