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.

Here is the SQL query you need:

SELECT meter_number 
FROM meter 
WHERE building_id IN (
    SELECT building_id 
    FROM building 
    WHERE building_type_id IN (
        SELECT building_type_id 
        FROM building_type 
        WHERE building_type_name = 'College'
    )
)
ORDER BY meter_number ASC;

This query works as follows:

1. The innermost subquery selects the building_type_id from the building_type table where the building_type_name is 'College'.
2. The next subquery selects the building_id from the building table where the building_type_id is in the list retrieved from the innermost subquery.
3. The outermost query selects the meter_number from the meter table where the building_id is in the list retrieved from the second subquery.
4. Finally, the results are ordered in ascending order by meter_number.

Here is the SQL query you asked for:

SELECT meter_number 
FROM meter 
WHERE building_id IN (
    SELECT building_id 
    FROM building 
    WHERE building_type_id IN (
        SELECT building_type_id 
        FROM building_type 
        WHERE building_type_name = 'College'
    )
)
ORDER BY meter_number ASC;

This query works as follows:

1. The innermost subquery selects the building_type_id from the building_type table where the building_type_name is 'College'.
2. The next subquery selects the building_id from the building table where the building_type_id is in the list retrieved from the first subquery.
3. The outermost query selects the meter_number from the meter table where the building_id is in the list retrieved from the second subquery.
4. Finally, the ORDER BY clause sorts the results in ascending order by meter_number.

Here is the SQL query you asked for:

SELECT meter_number 
FROM meter 
WHERE building_id IN (
    SELECT building_id 
    FROM building 
    WHERE building_type_id IN (
        SELECT building_type_id 
        FROM building_type 
        WHERE building_type_name = 'College'
    )
)
ORDER BY meter_number ASC;

This query works as follows:

1. The innermost subquery selects the building_type_id from the building_type table where the building_type_name is 'College'.
2. The next subquery selects the building_id from the building table where the building_type_id is in the list retrieved from the innermost subquery.
3. The outermost query selects the meter_number from the meter table where the building_id is in the list retrieved from the second subquery.
4. Finally, the results are ordered in ascending order by meter_number.