The SQL query to display all the columns from the student table whose score is in the range of 80 to 90 would be:

```sql
SELECT *
FROM student
WHERE score BETWEEN 80 AND 90;
```

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

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

2. `FROM student` : This statement specifies the table from which we want to retrieve data, in this case, the 'student' table.

3. `WHERE score BETWEEN 80 AND 90` : This is a condition to filter the records. It selects the records where the 'score' is between 80 and 90.

Question

The SQL query to display all the columns from the student table whose score is in the range of 80 to 90 would be:

```sql
SELECT * 
FROM student 
WHERE score BETWEEN 80 AND 90;
```

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

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

2. `FROM student` : This statement specifies the table from which we want to retrieve data, in this case, the 'student' table.

3. `WHERE score BETWEEN 80 AND 90` : This is a condition to filter the records. It selects the records where the 'score' is between 80 and 90.

Knowee AI · Accepted Answer

The SQL query to display all the columns from the student table whose score is in the range of 80 to 90 would be:

```sql
SELECT * 
FROM student 
WHERE score BETWEEN 80 AND 90;
```

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

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

2. `FROM student` : This statement specifies the table from which we want to retrieve data, in this case, the 'student' table.

3. `WHERE score BETWEEN 80 AND 90` : This is a condition to filter the records. It selects the records where the 'score' is between 80 and 90.

Select the query to display all the columns from the student table whose score is in the range of 80 to 90.