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
Question
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
Solution
Based on your instructions, it seems like you are asking for a SQL query. Here is a query that should meet your requirements:
SELECT *
FROM bill
WHERE total_units > 10000
ORDER BY total_units DESC;
This query will select all columns from the bill table where the total_units is greater than 10000, and it will sort the results in descending order by total_units.
Similar Questions
Write a query to display the details of all the bills whose 'total_units' greater than 10000, sorted by total_units in descending order.
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.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]SubmitSaveExecutePrevious Submission
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.
Write a query to display the total_units, payable_amount and fine_amount of bill table. Display the records in descending order based on their total_units
Write a query to display the meter_number,owner_name and address of the owner who paid fine most number of times. If there are multiple records display in ascending order based on owner_name.Note:1. Display only the below 3 columns, i. meter_number ii. owner_name iii. address with the condition who paid fine most number of times.2. Use Joins3. Tables involved are building, meter and bill4. Order by is mandatory.5. Compare your executed result with the sample output given below.Sample output:SubmitSaveExecuteValidatePrevious Submission
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.