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:

Create a view named 'meter_details' to select all the details of the buildings whose meter_number starts with 'SG' and ends with '2'.Note:1. Do not change the name of the view2. Include all the columns present in the building table. Select only the building with the meter_number starts with 'SG' and ends with '2'.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 "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:Created view will contain the following same data:[only few records shown here] SubmitSaveExecutePrevious Submission1​

Write a query to display the total_units and payable_amount of the particular meter number 'SG934826'.Note:1. Display only the total_units and payable_amount columns present in the bill table where meter_number is ‘SG934826’. Use subqueries to achieve this.2. Tables involved are bill and meter.

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 'bill_details' to select all the details of the bills which has completed payment with no fine amount.Note:1. Do not change the name of the view2. Include all the columns present in the bill table. But include only the bills which has completed payment with no fine_amount.3. Specify condition on is_payed and fine_amount column of bill table. If is_payed is 1 then it indicates the bills are paid. And if fine_amount is null then it indicates the bill paid with no fine_amount.4. 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: