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.Note:1. Display all the columns present in the bill table.2. Specify the condition and retrieve the correct rows in the result(condition need to be specified on due_date column).3. You can compare your executed result with the sample output given below.4. Order by is mandatorySample Output: [Only few records are shown here]
Question
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.Note:1. Display all the columns present in the bill table.2. Specify the condition and retrieve the correct rows in the result(condition need to be specified on due_date column).3. You can compare your executed result with the sample output given below.4. Order by is mandatorySample Output: [Only few records are shown here]
Solution
The SQL query you're looking for would look something like this:
SELECT *
FROM bill
WHERE due_date = '2017-10-01'
ORDER BY payable_amount DESC;
Here's what this query does, step by step:
-
SELECT * FROM bill: This part of the query selects all columns from thebilltable. -
WHERE due_date = '2017-10-01': This is the condition that filters the records. It only includes the bills where thedue_dateis '2017-10-01'. -
ORDER BY payable_amount DESC: This part of the query sorts the results in descending order based on thepayable_amountcolumn. The bill with the highestpayable_amountwill be shown first.
Similar Questions
Write a query to display the details of the 'bill' whose payment is not completed. Display the records in ascending order based on due_date.Note:1. Display all the columns present in the bill table.2. Specify the condition and retrieve the correct rows in the result. (condition need to be specified on is_payed column. If is_payed is 0, then the payment is not completed.)3. You can compare your executed result with the sample output given below.4. Order by is mandatory
Write a query to display all the details of all the 'bills' whose payment_date is on the year 2018, sorted by payable_amount in descending order.Note:1. Display all the columns present in the bill table.2. Specify the condition and retrieve the correct rows in the result(condition need to be specified on payment_date column).3. You can compare your executed result with the sample output given below.4. Order by is mandatorySample Output:
Write a query to display all the details of bills whose payment_date is on 2nd day of the month and also display the records in descending order based on the total_units.Note:1. Display all the columns present in the bill table whose payment_date is on 2nd day of the month. (day will be 01,02,03,...31)2. Order by is mandatory3. Compare your executed result with the sample output given below.
Write a query to display all the 'bills' with 'meter' details. Display the records in ascending order based on meter number.Note:1. Display all the columns of bill and meter table2. Use Joins3. Tables involved bill and meter4. Order by is mandatory5. Compare your executed result with the sample output given below.Sample output: [Only few records are shown here]ID METER_ID MONTH YEAR DUE_DATE TOTAL_UNITS PAYABLE_AMOUNT IS_PAYED PAYMENT_D FINE_AMOUNT ID METER_NUMBER BUILDING_ID39 26 8 2017 01-SEP-17 20700 724500 1 14-SEP-17 72450 26 SG190123 2614 10 10 2017 01-NOV-17 750 16875 1 09-NOV-17 1687.5 10 SG198329 10
Write a query to display bill id, meter_id, month, year, total_units, payable_amount and due_date of all the bills. Display the due_date in the format like June 17, 2003. Give an alias name as 'formatted_due_date'. Display all the records sorted in ascending order based on bill id.
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.