Write a query to display the sum of 12th hour unit consumption from electricity_reading table. Give an alias name to the sum of 12th hour consumption as 'sum_12th_hour_consumption'.Note:1. Display only the sum of 12th hour unit consumption from electricity reading.(12th hour reading will be h12 column).2. Specify the alias name without any mistake.3. Compare your executed result with the sample output given below.Sample output:
Question
Write a query to display the sum of 12th hour unit consumption from electricity_reading table. Give an alias name to the sum of 12th hour consumption as 'sum_12th_hour_consumption'.Note:1. Display only the sum of 12th hour unit consumption from electricity reading.(12th hour reading will be h12 column).2. Specify the alias name without any mistake.3. Compare your executed result with the sample output given below.Sample output:
Solution
Here is the SQL query you need to write to get the sum of 12th hour unit consumption from the electricity_reading table:
SELECT SUM(h12) AS sum_12th_hour_consumption
FROM electricity_reading;
This query works as follows:
-
SELECT SUM(h12): This part of the query is used to calculate the sum of all values in theh12column, which represents the 12th hour unit consumption. -
AS sum_12th_hour_consumption: This part of the query is used to give an alias name to the sum of 12th hour consumption. The alias name is 'sum_12th_hour_consumption'. -
FROM electricity_reading;: This part of the query specifies the table from which to retrieve the data. In this case, the data is retrieved from theelectricity_readingtable.
Similar Questions
Write a query to display the average 8th hour unit consumption from electricity reading. Give an alias name to the average 8th hour consumption as 'average_8th_hour_consumption'.Note:1. Display only the average 8th hour unit consumption from electricity reading.(8th hour reading will be h8 column).2. Specify the alias name without any mistake.3. Compare your executed result with the sample output given below.Sample output:
Write a query to display the average total_units of electricity consumption from the electricity_reading table.Give an alias name to the average units as 'average_units_of_electricity'.Note:1. Display only the average total_units of electricity consumption from electricity reading.2. Specify the alias name without any mistake.3. Compare your executed result with the sample output given below.Sample output:
Write a query to display the sum of h20 and average of h20 from the electricity_reading table consumed by the building_type named as 'Commercial' on 8PM. Give an alias name for total as 'total_amount' and average as 'average_amount'.Note:1. Display only the sum of h20 and average of h20 from the electricity_reading table consumed by the building_type named as 'Commercial' on 8PM.2. Tables involved are electricity_reading, meter, building, building_type and electricity_connection_type3. Specify the alias name without any mistake.4. Compare your executed result with the sample output given below.
Write a query to display the number of electricity_reading in which the total_units per day is greater than 500. Give an alias name as 'count_total_units_500'.Note:1. Display only the number of electricity_reading where total_units per day is greater than 500.2. Specify the alias name without any mistake.3. Specify condition on total_units column of electricity_reading table.3. Compare your executed result with the sample output given below.Sample output:
Write a query to display the minimum total_units consumption from electricity_reading table. Give an alias name to the minimum total units as 'min_total_units'.Note:1. Display only the minimum total_units consumption from electricity_reading table.2. Specify the alias name without any mistake.3. Compare your executed result with the sample output given below.Sample output:
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.