Display only the name column present in the building_type table where meter_number is ‘SG824012’. Use subqueries to achieve this.2. Tables involved are building_type, building and meter.3. Compare your executed result with the sample output given below.Sample output:

Display only the contact_number column present in the building table where building_type name is ‘Police Station’. Use subqueries to achieve this.2. Tables involved are building_type and building.3. Order by is mandatory.4. Compare your executed result with the sample output given below.

Write a query to display the meter_number of the building_type named 'College'. Display the records in ascending order based on their meter_number.Note:1. Display only the meter_number column present in the meter table where building_type name is ‘College’. Use subqueries to achieve this.2. Tables involved are building_type, building and meter.3. Order by is mandatory4. Compare your executed result with the sample output given below.

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.3. Compare your executed result with the sample output given below.Sample output:

Write a query to display all 'meter_number' from meter table.

Write a query to display all the details of the 'meter' whose meter_number starts with 'S' and ends with '6'.Note:1. Display all the columns present in the meter table.2. Specify the condition and retrieve the correct rows in the result. (condition need to be specified on meter_number column)3. You can compare your executed result with the sample output given below.Sample output: