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 the step by step explanation:

1. `SELECT *` : This statement is used to select all the columns of the 'building' table.

2. `FROM building` : This statement specifies the table from which to retrieve the data, in this case, it's the 'building' table.

3. `WHERE owner_name = 'Nicholas'` : This is a condition to filter the results. It will only include 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 the step by step explanation:

1. `SELECT *` : This statement is used to select all the columns of the 'building' table.

2. `FROM building` : This statement specifies the table from which to retrieve the data, in this case, it's the 'building' table.

3. `WHERE owner_name = 'Nicholas'` : This is a condition to filter the results. It will only include 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 the step by step explanation:

1. `SELECT *` : This statement is used to select all the columns of the 'building' table.

2. `FROM building` : This statement specifies the table from which to retrieve the data, in this case, it's the 'building' table.

3. `WHERE owner_name = 'Nicholas'` : This is a condition to filter the results. It will only include the rows where the owner_name is 'Nicholas'.

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