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
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.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
Solution
Here is the SQL query you need:
SELECT *
FROM bills
WHERE YEAR(payment_date) = 2018
ORDER BY payable_amount DESC;
This query works as follows:
SELECT * FROM bills: This selects all columns from the 'bills' table.WHERE YEAR(payment_date) = 2018: This filters the selected rows, only keeping those where the year of the 'payment_date' is 2018.ORDER BY payable_amount DESC: This sorts the remaining rows by the 'payable_amount' column in descending order.
Similar Questions
QueryQ13Write 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.
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]
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 orde
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 the details of all the bills whose 'total_units' greater than 10000, sorted by total_units 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 total_units 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]SubmitSaveExecutePrevious Submission1
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.