It seems like you're asking for a SQL query. Here's how you can do it:

```sql
SELECT *
FROM building
WHERE building_type_id IN (
SELECT building_type_id
FROM building_type
WHERE building_type_name = 'Library'
)
ORDER BY building_name;
```

This query works as follows:

1. The subquery `(SELECT building_type_id FROM building_type WHERE building_type_name = 'Library')` selects the `building_type_id` of the building type named 'Library'.

2. The main query selects all columns from the `building` table where `building_type_id` is in the list of IDs returned by the subquery.

3. The `ORDER BY building_name` clause sorts the result by the `building_name` column.

Please replace `building_name` and `building_type_id` with the actual column names in your tables if they are different. Also, make sure to run this query in your SQL environment to see if it works as expected.

Question

It seems like you're asking for a SQL query. Here's how you can do it:

```sql
SELECT *
FROM building
WHERE building_type_id IN (
    SELECT building_type_id
    FROM building_type
    WHERE building_type_name = 'Library'
)
ORDER BY building_name;
```

This query works as follows:

1. The subquery `(SELECT building_type_id FROM building_type WHERE building_type_name = 'Library')` selects the `building_type_id` of the building type named 'Library'.

2. The main query selects all columns from the `building` table where `building_type_id` is in the list of IDs returned by the subquery.

3. The `ORDER BY building_name` clause sorts the result by the `building_name` column.

Please replace `building_name` and `building_type_id` with the actual column names in your tables if they are different. Also, make sure to run this query in your SQL environment to see if it works as expected.

Knowee AI · Accepted Answer

It seems like you're asking for a SQL query. Here's how you can do it:

```sql
SELECT *
FROM building
WHERE building_type_id IN (
    SELECT building_type_id
    FROM building_type
    WHERE building_type_name = 'Library'
)
ORDER BY building_name;
```

This query works as follows:

1. The subquery `(SELECT building_type_id FROM building_type WHERE building_type_name = 'Library')` selects the `building_type_id` of the building type named 'Library'.

2. The main query selects all columns from the `building` table where `building_type_id` is in the list of IDs returned by the subquery.

3. The `ORDER BY building_name` clause sorts the result by the `building_name` column.

Please replace `building_name` and `building_type_id` with the actual column names in your tables if they are different. Also, make sure to run this query in your SQL environment to see if it works as expected.

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

Question

Solution

Similar Questions

Upgrade your grade with Knowee