Knowee
Questions
Features
Study Tools

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'.

Question

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'.

🧐 Not the exact question you are looking for?Go ask a question

Solution

Sure, here is the SQL query you asked for:

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

This query works as follows:

  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, 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 for selecting the data. It selects the rows where the due_date is '2017-10-01'.

This problem has been solved

Similar Questions

Write a query to display the sum of payable_amount whose payment_date is on the year 2018. Give an alias name to the total payable_amount as 'sum_payable_amount'.

Write a query to display the sum of payable_amount and fine_amount of all the bills from bill table. Give an alias name to the sum of payable amount and fine amount as 'sum_payable_and_fine_amount'.

Write a query to display the sum of payable_amount whose payment_date is on the year 2018. Give an alias name to the total payable_amount as 'sum_payable_amount'.Note:1. Display only the sum of payable_amount in the given year from bill table.(only for the year 2018).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 payment_date column).4. Compare your executed result with the sample output given below.

Write a query to display the details of all the 'bill' with the due_date on '2017-10-01'.Display the records in descending order based on their payable_amount.

Write a query to display the average fine_amount of the bills whose payment_date is on the year 2018. Give an alias name to the average fine amount as 'average_fine_amount'.

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.