Here is a SQL query that will give you the desired result:

```sql
SELECT owner_name, address, contact_number
FROM buildings
WHERE email_address IS NULL
ORDER BY owner_name ASC;
```

Here's a step-by-step breakdown of the query:

1. `SELECT owner_name, address, contact_number`: This part of the query selects the columns that you want to display in your result. In this case, you want to display the owner's name, address, and contact number.

2. `FROM buildings`: This part of the query specifies the table from which you want to retrieve the data. In this case, the table is `buildings`.

3. `WHERE email_address IS NULL`: This is the condition that the rows must meet in order to be included in the result. In this case, you only want rows where the `email_address` is null, which means that the building does not have an email address.

4. `ORDER BY owner_name ASC`: This part of the query sorts the result in ascending order by the `owner_name`. If you wanted to sort in descending order, you would use `DESC` instead of `ASC`.

Question

Here is a SQL query that will give you the desired result:

```sql
SELECT owner_name, address, contact_number
FROM buildings
WHERE email_address IS NULL
ORDER BY owner_name ASC;
```

Here's a step-by-step breakdown of the query:

1. `SELECT owner_name, address, contact_number`: This part of the query selects the columns that you want to display in your result. In this case, you want to display the owner's name, address, and contact number.

2. `FROM buildings`: This part of the query specifies the table from which you want to retrieve the data. In this case, the table is `buildings`.

3. `WHERE email_address IS NULL`: This is the condition that the rows must meet in order to be included in the result. In this case, you only want rows where the `email_address` is null, which means that the building does not have an email address.

4. `ORDER BY owner_name ASC`: This part of the query sorts the result in ascending order by the `owner_name`. If you wanted to sort in descending order, you would use `DESC` instead of `ASC`.

Knowee AI · Accepted Answer

Here is a SQL query that will give you the desired result:

```sql
SELECT owner_name, address, contact_number
FROM buildings
WHERE email_address IS NULL
ORDER BY owner_name ASC;
```

Here's a step-by-step breakdown of the query:

1. `SELECT owner_name, address, contact_number`: This part of the query selects the columns that you want to display in your result. In this case, you want to display the owner's name, address, and contact number.

2. `FROM buildings`: This part of the query specifies the table from which you want to retrieve the data. In this case, the table is `buildings`.

3. `WHERE email_address IS NULL`: This is the condition that the rows must meet in order to be included in the result. In this case, you only want rows where the `email_address` is null, which means that the building does not have an email address.

4. `ORDER BY owner_name ASC`: This part of the query sorts the result in ascending order by the `owner_name`. If you wanted to sort in descending order, you would use `DESC` instead of `ASC`.

QueryQ14Write a query to display the owner_name, address and contact_number of the buildings which does not have an email_address. Display the records in ascending order based on their owner_name.

Question

Solution

Similar Questions

Upgrade your grade with Knowee