To answer your question, I'm assuming that the 'bill' table contains the 'fine_total_amount' and 'meter_number', the 'meter' table contains the 'meter_number' and 'building_id', and the 'building' table contains the 'building_id', 'owner_name', and 'address'.

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

```sql
SELECT m.meter_number, b.owner_name, b.address
FROM bill bl
JOIN meter m ON bl.meter_number = m.meter_number
JOIN building b ON m.building_id = b.building_id
WHERE bl.fine_total_amount = (
SELECT DISTINCT fine_total_amount
FROM bill
ORDER BY fine_total_amount ASC
LIMIT 1 OFFSET 1
)
ORDER BY b.owner_name ASC;
```

This query works as follows:

1. It joins the 'bill', 'meter', and 'building' tables based on the 'meter_number' and 'building_id'.
2. It selects the 'meter_number', 'owner_name', and 'address' from the joined tables.
3. It filters the results to only include those where the 'fine_total_amount' is equal to the second least 'fine_total_amount' in the 'bill' table. This is achieved by using a subquery that selects the distinct 'fine_total_amount' values from the 'bill' table, orders them in ascending order, and then limits the results to the second row (using 'LIMIT 1 OFFSET 1').
4. Finally, it orders the results in ascending order based on the 'owner_name'.

Question

To answer your question, I'm assuming that the 'bill' table contains the 'fine_total_amount' and 'meter_number', the 'meter' table contains the 'meter_number' and 'building_id', and the 'building' table contains the 'building_id', 'owner_name', and 'address'.

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

```sql
SELECT m.meter_number, b.owner_name, b.address
FROM bill bl
JOIN meter m ON bl.meter_number = m.meter_number
JOIN building b ON m.building_id = b.building_id
WHERE bl.fine_total_amount = (
    SELECT DISTINCT fine_total_amount
    FROM bill
    ORDER BY fine_total_amount ASC
    LIMIT 1 OFFSET 1
)
ORDER BY b.owner_name ASC;
```

This query works as follows:

1. It joins the 'bill', 'meter', and 'building' tables based on the 'meter_number' and 'building_id'.
2. It selects the 'meter_number', 'owner_name', and 'address' from the joined tables.
3. It filters the results to only include those where the 'fine_total_amount' is equal to the second least 'fine_total_amount' in the 'bill' table. This is achieved by using a subquery that selects the distinct 'fine_total_amount' values from the 'bill' table, orders them in ascending order, and then limits the results to the second row (using 'LIMIT 1 OFFSET 1').
4. Finally, it orders the results in ascending order based on the 'owner_name'.

Knowee AI · Accepted Answer

To answer your question, I'm assuming that the 'bill' table contains the 'fine_total_amount' and 'meter_number', the 'meter' table contains the 'meter_number' and 'building_id', and the 'building' table contains the 'building_id', 'owner_name', and 'address'.

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

```sql
SELECT m.meter_number, b.owner_name, b.address
FROM bill bl
JOIN meter m ON bl.meter_number = m.meter_number
JOIN building b ON m.building_id = b.building_id
WHERE bl.fine_total_amount = (
    SELECT DISTINCT fine_total_amount
    FROM bill
    ORDER BY fine_total_amount ASC
    LIMIT 1 OFFSET 1
)
ORDER BY b.owner_name ASC;
```

This query works as follows:

1. It joins the 'bill', 'meter', and 'building' tables based on the 'meter_number' and 'building_id'.
2. It selects the 'meter_number', 'owner_name', and 'address' from the joined tables.
3. It filters the results to only include those where the 'fine_total_amount' is equal to the second least 'fine_total_amount' in the 'bill' table. This is achieved by using a subquery that selects the distinct 'fine_total_amount' values from the 'bill' table, orders them in ascending order, and then limits the results to the second row (using 'LIMIT 1 OFFSET 1').
4. Finally, it orders the results in ascending order based on the 'owner_name'.

Question

Solution

Similar Questions

Upgrade your grade with Knowee