QueryQQ9Create a view named "daily_readings" to display the daily hourly readings from h1 to h24 for each meter with meter number displayed.Note:1. Do not change the name of the view2. Include only 3 columns,  meter_number from meter table and its corresponding reading hours(h1-h24) from the electricity_reading table.3. Use Joins. Tables involved are meter and electricity_reading3. Submit only the CREATE VIEW query.Instructions:1. Create the view successfully2. Once the view is created, check the correctness of the virtual table by displaying all the records in it.4. DO NOT submit the select query. Submit only the CREATE VIEW query.Sample Output:

Create a view named 'electricity_reading_details' to select all the details of the electricity_reading whose total_units per day is greater than 500 units.Note:1. Do not change the name of the view2. Include all the column present in the electricity_reading table. Select only the records with the total_units greater than 500.3. Submit only the CREATE VIEW query.Instructions:1. Create the view successfully2. Once the view is created, check the correctness of the virtual table by displaying all the records in it.3. DO NOT submit the select query. Submit only the CREATE VIEW query.Sample Output:Created view will contain the following same data:

Create a view named "all_payable_amount" to select the meter_number from meter table and its corresponding payable_amount from the bill table.Note:1. Do not change the name of the view2. Include only 2 columns,  meter_number from meter table and its corresponding payable_amount from the bill table.3. Use Joins. Tables involved are meter and bill4. Submit only the CREATE VIEW query.Instructions:1. Create the view successfully2. Once the view is created, check the correctness of the virtual table by displaying all the records in it.3. DO NOT submit the select query. Submit only the CREATE VIEW query.Sample Output:Created view will contain the following same data:

QueryQQ11Write a query to display the meter_number from the meter table which got maximum total_units during 8PM for a day in the electricity_reading.Note:1. Display only the meter_number from the meter table which got maximum total_units during 8PM for a day in the electricity_reading. ( 8PM reading will be in h20 column).2. Tables involved are meter and electricity_reading3. Compare your executed result with the sample output given below.

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 meter_number from the meter table which got maximum total_units during 8PM for a day in the electricity_reading.