Which of the following SQL comparison operators queries is correct?
A. SELECT name, course name FROM student WHERE age is more than 50 and less than 80.
B. SELECT name, course name FROM student WHERE the age is greater than 50 and less than 80;
C. SELECT name, course name FROM student WHERE age >50 and >80;
D. None of these are correct.
Answer:C
Which of the following SQL comparison operators queries is correct?
A. SELECT name, course name FROM student WHERE age is more than 50 and less than 80. B. SELECT name, course name FROM student WHERE the age is greater than 50 and less than 80; C. SELECT name, course name FROM student WHERE age >50 and >80; D. None of these are correct.
Explanation: SELECT name, course name FROM student WHERE age is greater than 50 and less than 80 years old;