It seems like you're asking for a SQL query. Here's a step-by-step guide on how to write it:

1. First, you need to join the three tables. You can do this using the JOIN keyword. The tables are 'building', 'meter', and 'bill'. You need to find a common column between these tables to join them. Let's assume 'building_id' is a common column between 'building' and 'meter', and 'meter_id' is a common column between 'meter' and 'bill'.

```sql
SELECT building.owner_name, SUM(bill.payable_amount) AS TotalBillAmount
FROM building
JOIN meter ON building.building_id = meter.building_id
JOIN bill ON meter.meter_id = bill.meter_id
```

2. Next, you need to add a WHERE clause to filter the records for the year 2017. Let's assume 'bill_date' is a column in 'bill' table which stores the date of the bill.

```sql
WHERE YEAR(bill.bill_date) = 2017
```

3. Then, you need to GROUP BY 'owner_name' to get the sum of 'payable_amount' for each owner.

```sql
GROUP BY building.owner_name
```

4. To get the owner who paid the maximum bill amount, you can use a subquery in the HAVING clause to compare the sum of 'payable_amount' with the maximum sum of 'payable_amount'.

```sql
HAVING SUM(bill.payable_amount) = (SELECT MAX(SUM(payable_amount)) FROM bill WHERE YEAR(bill_date) = 2017)
```

5. Finally, you need to ORDER BY 'owner_name' in ascending order.

```sql
ORDER BY building.owner_name ASC;
```

So, the complete SQL query would be:

```sql
SELECT building.owner_name, SUM(bill.payable_amount) AS TotalBillAmount
FROM building
JOIN meter ON building.building_id = meter.building_id
JOIN bill ON meter.meter_id = bill.meter_id
WHERE YEAR(bill.bill_date) = 2017
GROUP BY building.owner_name
HAVING SUM(bill.payable_amount) = (SELECT MAX(SUM(payable_amount)) FROM bill WHERE YEAR(bill_date) = 2017)
ORDER BY building.owner_name ASC;
```

Please replace the column names and table names with the actual ones in your database.

Question

It seems like you're asking for a SQL query. Here's a step-by-step guide on how to write it:

1. First, you need to join the three tables. You can do this using the JOIN keyword. The tables are 'building', 'meter', and 'bill'. You need to find a common column between these tables to join them. Let's assume 'building_id' is a common column between 'building' and 'meter', and 'meter_id' is a common column between 'meter' and 'bill'.

```sql
SELECT building.owner_name, SUM(bill.payable_amount) AS TotalBillAmount
FROM building
JOIN meter ON building.building_id = meter.building_id
JOIN bill ON meter.meter_id = bill.meter_id
```

2. Next, you need to add a WHERE clause to filter the records for the year 2017. Let's assume 'bill_date' is a column in 'bill' table which stores the date of the bill.

```sql
WHERE YEAR(bill.bill_date) = 2017
```

3. Then, you need to GROUP BY 'owner_name' to get the sum of 'payable_amount' for each owner.

```sql
GROUP BY building.owner_name
```

4. To get the owner who paid the maximum bill amount, you can use a subquery in the HAVING clause to compare the sum of 'payable_amount' with the maximum sum of 'payable_amount'.

```sql
HAVING SUM(bill.payable_amount) = (SELECT MAX(SUM(payable_amount)) FROM bill WHERE YEAR(bill_date) = 2017)
```

5. Finally, you need to ORDER BY 'owner_name' in ascending order.

```sql
ORDER BY building.owner_name ASC;
```

So, the complete SQL query would be:

```sql
SELECT building.owner_name, SUM(bill.payable_amount) AS TotalBillAmount
FROM building
JOIN meter ON building.building_id = meter.building_id
JOIN bill ON meter.meter_id = bill.meter_id
WHERE YEAR(bill.bill_date) = 2017
GROUP BY building.owner_name
HAVING SUM(bill.payable_amount) = (SELECT MAX(SUM(payable_amount)) FROM bill WHERE YEAR(bill_date) = 2017)
ORDER BY building.owner_name ASC;
```

Please replace the column names and table names with the actual ones in your database.

Knowee AI · Accepted Answer