Write a query to display the meter_id and total_units of electricity_reading whose '13th' hour reading is lesser than the '14th' hour reading, Display the records in descending order based on their total_units.Note:1. Display only the columns meter_id and total_units present in the electricity_reading table.2. Specify the condition and retrieve the correct rows in the result. (condition need to be specified on h13 and h14 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 meter_id and total_units of electricity_reading whose '13th' hour reading is lesser than the '14th' hour reading, Display the records in descending order based on their total_units.Note:1. Display only the columns meter_id and total_units present in the electricity_reading table.2. Specify the condition and retrieve the correct rows in the result. (condition need to be specified on h13 and h14 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 language of the text is SQL (Structured Query Language). Here is the query based on the given requirements:
SELECT meter_id, total_units
FROM electricity_reading
WHERE h13 < h14
ORDER BY total_units DESC;
This query does the following:
- Selects the
meter_idandtotal_unitscolumns from theelectricity_readingtable. - Filters the rows where the 13th hour reading (
h13) is less than the 14th hour reading (h14). - Orders the result in descending order based on the
total_unitscolumn.
Similar Questions
Write a query to display the meter_number from the meter table which got minimum total_units during 9PM for a day in the electricity_reading. Display the records in ascending order based on their meter_number.Note:1. Display only the meter_number from the meter table which got minimum total_units during 9PM. ( 9PM reading will be in h21 column).2. Tables involved are meter and electricity_reading3. Compare your executed result with the sample output given below.
Write a query to display unique 12th hour reading present in the electricity_reading table. Display the records sorted in descending order based on h12.Note:1. Display only the unique records present in the column named h12 in the electricity_reading table.2. Order by is mandatory
Write a query to display all the details of the 'electricity_reading' whose 'total_units' per day is between 500 and 1000.Display the records in ascending order based on their total_units.
Write a query to display the meter_number from the meter table which got minimum amount of total_units in a month. Display the records in ascending order based on their meter_number.Note:1. Display only the meter_number from the meter table which got minimum amount of total_units in a month.2. Tables involved are meter and bill3. Order by is mandatory4. Compare your executed result with the sample output given below.Sample output:
Write a query to display the electricity readings for the meters with meter number 'SG923564' and 'SG288942' in descending order based on the total units consumed per day.
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.