Write a query to display the sum of payable_amount with due_date '2017-10-01' from bill table. Give an alias name to the sum of payable amount as 'sum_payable_amount'.Note:1. Display only the sum of payable_amount with the given due_date from bill table.2. Specify the alias name without any mistake.3. Specify the condition and retrieve the correct rows in the result(condition need to be specified on due_date).4. Compare your executed result with the sample output given below.Sample output:

Here is the SQL query you need to write to get the desired output:

SELECT SUM(payable_amount) AS sum_payable_amount
FROM bill
WHERE due_date = '2017-10-01';

Let's break down this query:

1. SELECT SUM(payable_amount) AS sum_payable_amount: This part of the query is used to calculate the sum of the payable_amount column. The AS keyword is used to give this sum a name, or alias, which is sum_payable_amount.

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

3. WHERE due_date = '2017-10-01': This is the condition that the rows must meet in order to be included in the sum. Only the rows where due_date is '2017-10-01' will be included.

After executing this query, you will get the total payable amount for the bills due on '2017-10-01'.

The SQL query to achieve this would be:

SELECT SUM(payable_amount) AS sum_payable_amount
FROM bill
WHERE due_date = '2017-10-01';

Here's how this query works:

1. SELECT SUM(payable_amount) AS sum_payable_amount: This part of the query is used to calculate the sum of the payable_amount column. The AS keyword is used to give this sum a name, or alias, which is sum_payable_amount.

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

3. WHERE due_date = '2017-10-01': This is the condition that the rows must meet in order to be included in the sum. Only rows where the due_date is '2017-10-01' will be included.

After executing this query, you will get the total payable amount for the bills due on '2017-10-01'.

The SQL query to achieve this would be:

SELECT SUM(payable_amount) AS sum_payable_amount
FROM bill
WHERE due_date = '2017-10-01';

Here's the step by step explanation:

1. SELECT SUM(payable_amount) AS sum_payable_amount: This part of the query is used to calculate the sum of the payable_amount column from the bill table. The AS keyword is used to give this sum an alias name, sum_payable_amount.

2. FROM bill: This part of the query specifies the table from which we want to retrieve data, which is the bill table in this case.

3. WHERE due_date = '2017-10-01': This is the condition that filters the data. It only includes the rows where the due_date is '2017-10-01'.

When you run this query, it will return the sum of the payable_amount for all bills that have a due_date of '2017-10-01'. This sum will be displayed under a column named sum_payable_amount.

The SQL query to achieve this would be:

SELECT SUM(payable_amount) AS sum_payable_amount
FROM bill
WHERE due_date = '2017-10-01';

Here's the step by step explanation:

1. SELECT SUM(payable_amount) AS sum_payable_amount: This part of the query is used to calculate the sum of the payable_amount column from the bill table. The AS keyword is used to give an alias name to the sum of payable amount, which is sum_payable_amount.

2. FROM bill: This part of the query specifies the table from which we want to retrieve the data, which is the bill table.

3. WHERE due_date = '2017-10-01': This is the condition that needs to be met for the rows to be included in the result. It specifies that we only want to include rows where the due_date is '2017-10-01'.

When you run this query, it will return the sum of the payable_amount for all bills with a due_date of '2017-10-01', and this sum will be displayed under the column name sum_payable_amount.