Here is the SQL query that you need:

```sql
SELECT AVG(b.payable_amount) AS payable_amount
FROM bill b
JOIN meter m ON b.meter_id = m.id
JOIN building bu ON m.building_id = bu.id
JOIN building_type bt ON bu.building_type_id = bt.id
JOIN electricity_connection_type ect ON bt.electricity_connection_type_id = ect.id
JOIN slab s ON ect.slab_id = s.id
WHERE s.rate

Question

Here is the SQL query that you need:

```sql
SELECT AVG(b.payable_amount) AS payable_amount
FROM bill b
JOIN meter m ON b.meter_id = m.id
JOIN building bu ON m.building_id = bu.id
JOIN building_type bt ON bu.building_type_id = bt.id
JOIN electricity_connection_type ect ON bt.electricity_connection_type_id = ect.id
JOIN slab s ON ect.slab_id = s.id
WHERE s.rate < 24;
```

This query works as follows:

1. It joins the `bill` table with the `meter` table on the `meter_id` field.
2. Then it joins the result with the `building` table on the `building_id` field.
3. The result is then joined with the `building_type` table on the `building_type_id` field.
4. The `electricity_connection_type` table is joined on the `electricity_connection_type_id` field.
5. Finally, the `slab` table is joined on the `slab_id` field.
6. The `WHERE` clause filters out the records where the `rate` in the `slab` table is less than 24.
7. The `SELECT` statement calculates the average of the `payable_amount` from the `bill` table and gives it an alias name 'payable_amount'.

Knowee AI · Accepted Answer

Here is the SQL query that you need:

```sql
SELECT AVG(b.payable_amount) AS payable_amount
FROM bill b
JOIN meter m ON b.meter_id = m.id
JOIN building bu ON m.building_id = bu.id
JOIN building_type bt ON bu.building_type_id = bt.id
JOIN electricity_connection_type ect ON bt.electricity_connection_type_id = ect.id
JOIN slab s ON ect.slab_id = s.id
WHERE s.rate < 24;
```

This query works as follows:

1. It joins the `bill` table with the `meter` table on the `meter_id` field.
2. Then it joins the result with the `building` table on the `building_id` field.
3. The result is then joined with the `building_type` table on the `building_type_id` field.
4. The `electricity_connection_type` table is joined on the `electricity_connection_type_id` field.
5. Finally, the `slab` table is joined on the `slab_id` field.
6. The `WHERE` clause filters out the records where the `rate` in the `slab` table is less than 24.
7. The `SELECT` statement calculates the average of the `payable_amount` from the `bill` table and gives it an alias name 'payable_amount'.

Question

Solution

Similar Questions

Upgrade your grade with Knowee