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

```sql
SELECT contact_number
FROM building
WHERE building_type_id IN (
SELECT building_type_id
FROM building_type
WHERE building_type_name = 'Police Station'
)
ORDER BY contact_number;
```

Here's the step by step explanation:

1. The subquery `SELECT building_type_id FROM building_type WHERE building_type_name = 'Police Station'` is used to find the `building_type_id` of the 'Police Station' from the `building_type` table.

2. This `building_type_id` is then used in the main query to filter the `building` table and get the `contact_number` of buildings where `building_type_id` is the same as the one we got from the subquery.

3. Finally, the `ORDER BY contact_number` is used to sort the result by `contact_number`.

Please replace the table and column names with the actual ones in your database if they are different.

Question

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

```sql
SELECT contact_number 
FROM building 
WHERE building_type_id IN (
    SELECT building_type_id 
    FROM building_type 
    WHERE building_type_name = 'Police Station'
) 
ORDER BY contact_number;
```

Here's the step by step explanation:

1. The subquery `SELECT building_type_id FROM building_type WHERE building_type_name = 'Police Station'` is used to find the `building_type_id` of the 'Police Station' from the `building_type` table.

2. This `building_type_id` is then used in the main query to filter the `building` table and get the `contact_number` of buildings where `building_type_id` is the same as the one we got from the subquery.

3. Finally, the `ORDER BY contact_number` is used to sort the result by `contact_number`.

Please replace the table and column names with the actual ones in your database if they are different.

Knowee AI · Accepted Answer

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

```sql
SELECT contact_number 
FROM building 
WHERE building_type_id IN (
    SELECT building_type_id 
    FROM building_type 
    WHERE building_type_name = 'Police Station'
) 
ORDER BY contact_number;
```

Here's the step by step explanation:

1. The subquery `SELECT building_type_id FROM building_type WHERE building_type_name = 'Police Station'` is used to find the `building_type_id` of the 'Police Station' from the `building_type` table.

2. This `building_type_id` is then used in the main query to filter the `building` table and get the `contact_number` of buildings where `building_type_id` is the same as the one we got from the subquery.

3. Finally, the `ORDER BY contact_number` is used to sort the result by `contact_number`.

Please replace the table and column names with the actual ones in your database if they are different.

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.

Question

Solution

Similar Questions

Upgrade your grade with Knowee