Write a query to display the details of all the 'bills' with the due_date on '2017-10-01'.Display the records in descending order based on their payable_amount.
Question
Write a query to display the details of all the 'bills' with the due_date on '2017-10-01'.Display the records in descending order based on their payable_amount.
Solution 1
Here is the SQL query you need:
SELECT *
FROM bills
WHERE due_date = '2017-10-01'
ORDER BY payable_amount DESC;
This query works as follows:
SELECT * FROM bills: This selects all columns from the 'bills' table.WHERE due_date = '2017-10-01': This filters the records to only include those where the 'due_date' is '2017-10-01'.ORDER BY payable_amount DESC: This sorts the resulting records in descending order based on the 'payable_amount' column.
Solution 2
Here is the SQL query you need:
SELECT *
FROM bills
WHERE due_date = '2017-10-01'
ORDER BY payable_amount DESC;
This query works as follows:
SELECT * FROM bills: This selects all columns from the 'bills' table.WHERE due_date = '2017-10-01': This filters the records to only include those where the 'due_date' is '2017-10-01'.ORDER BY payable_amount DESC: This sorts the resulting records in descending order based on the 'payable_amount' column.
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.
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.
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.
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:SubmitSaveExecutePrevious Submission
Write a query to display the owner_name, building_type name, meter_number and payment_status of the bill which are raised in the month December 2017.Payment_Status will be payment_date is the payment is done, else if the payment is not done then display as 'Not Paid Yet'. Give an alias name as 'Payment_Status'. Display the record in ascending order based on owner_name.Note:1. 1. Display only the below 4 columns, i. owner_name ii. building_type name iii. meter_number iv. payment_statusraised in the month december 2017.2. Use Joins3. Tables involved are bill, meter, building and building_type4. Specify condition on year, month of bill table.5. Order by is mandatory. 6. Specify the alias name without any mistake.7. Compare your executed result with the sample output given below.
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.