sql

Question

and please also explain
SELECT name students
WHERE age
18 22;
(challenge 2 part 7)

Answer 1

SELECT name FROM students
WHERE age between 18 and 22;

It means:
1. you have a table called "students"
2. in this table you have two columns of interest: "name" and "age"
3. you SELECT FROM the table named "students"...
4. ...the values in the column "name"...
5. ...corresponding to the values between​ 18 and 22 in the column "age"

so you' ll obtain a new table with the name of the students who are between 18 and 22

Answer 2

thanks a lot for the help.Really appreciate it.it helped a lot