Sure, here is the SQL query you asked for:

```sql
SELECT AVG(payable_amount) AS average_payable_amount
FROM bill
WHERE payable_amount 10000;
```

Here's the step by step explanation:

1. `SELECT AVG(payable_amount) AS average_payable_amount`: This part of the query is used to calculate the average of the `payable_amount` column. The `AVG` function does this calculation. The `AS` keyword is used to give a new name or alias to the result, which is `average_payable_amount` in this case.

2. `FROM bill`: This part of the query specifies the table we are selecting data from, which is the `bill` table.

3. `WHERE payable_amount 10000`: This is the condition for selecting the data. Only the rows where `payable_amount` is greater than 10000 are considered for calculating the average.

Question

Sure, here is the SQL query you asked for:

```sql
SELECT AVG(payable_amount) AS average_payable_amount
FROM bill
WHERE payable_amount > 10000;
```

Here's the step by step explanation:

1. `SELECT AVG(payable_amount) AS average_payable_amount`: This part of the query is used to calculate the average of the `payable_amount` column. The `AVG` function does this calculation. The `AS` keyword is used to give a new name or alias to the result, which is `average_payable_amount` in this case.

2. `FROM bill`: This part of the query specifies the table we are selecting data from, which is the `bill` table.

3. `WHERE payable_amount > 10000`: This is the condition for selecting the data. Only the rows where `payable_amount` is greater than 10000 are considered for calculating the average.

Knowee AI · Accepted Answer

Sure, here is the SQL query you asked for:

```sql
SELECT AVG(payable_amount) AS average_payable_amount
FROM bill
WHERE payable_amount > 10000;
```

Here's the step by step explanation:

1. `SELECT AVG(payable_amount) AS average_payable_amount`: This part of the query is used to calculate the average of the `payable_amount` column. The `AVG` function does this calculation. The `AS` keyword is used to give a new name or alias to the result, which is `average_payable_amount` in this case.

2. `FROM bill`: This part of the query specifies the table we are selecting data from, which is the `bill` table.

3. `WHERE payable_amount > 10000`: This is the condition for selecting the data. Only the rows where `payable_amount` is greater than 10000 are considered for calculating the average.

Write a query to display the average payable_amount from bill table where payable_amount is greater than 10000. Give an alias name to the average payable amount as 'average_payable_amount'.

Question

Solution

Similar Questions

Upgrade your grade with Knowee