Sure, here is a SQL query that will display all the details of the 'building' whose owner_name is 'Nicholas':

```sql
SELECT *
FROM building
WHERE owner_name = 'Nicholas';
```

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

1. `SELECT *` - This part of the query is used to select all columns of the data from the table.

2. `FROM building` - This part of the query specifies the table ('building') from which to retrieve the data.

3. `WHERE owner_name = 'Nicholas'` - This is the condition that filters the records. It only selects the rows where the owner_name is 'Nicholas'.

Question

Sure, here is a SQL query that will display all the details of the 'building' whose owner_name is 'Nicholas':

```sql
SELECT *
FROM building
WHERE owner_name = 'Nicholas';
```

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

1. `SELECT *` - This part of the query is used to select all columns of the data from the table.

2. `FROM building` - This part of the query specifies the table ('building') from which to retrieve the data.

3. `WHERE owner_name = 'Nicholas'` - This is the condition that filters the records. It only selects the rows where the owner_name is 'Nicholas'.

Knowee AI · Accepted Answer

Sure, here is a SQL query that will display all the details of the 'building' whose owner_name is 'Nicholas':

```sql
SELECT *
FROM building
WHERE owner_name = 'Nicholas';
```

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

1. `SELECT *` - This part of the query is used to select all columns of the data from the table.

2. `FROM building` - This part of the query specifies the table ('building') from which to retrieve the data.

3. `WHERE owner_name = 'Nicholas'` - This is the condition that filters the records. It only selects the rows where the owner_name is 'Nicholas'.

Write a query to display all the details of the 'building' whose owner_name is 'Nicholas'