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.
Question
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.
Solution
Sure, here is the SQL query you need:
SELECT *
FROM bills
WHERE YEAR(payment_date) = 2018
ORDER BY payable_amount DESC;
This query will select all columns from the 'bills' table where the year of the 'payment_date' is 2018. The results will be sorted by the 'payable_amount' column in descending order.
Similar Questions
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 details of all the 'bills' with the due_date on '2017-10-01'.Display the records in descending order based on their payable_amount.
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 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 bills whose payment_date is on 2nd day of the month and also display the records in descending order based on the total_units.
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.