Which of the following query is correct for using comparison operators in SQL?
- SELECT name, course_name FROM student WHERE age>50 and <80;
- SELECT name, course_name FROM student WHERE age>50 and age <80;
- SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;
- None of these
(b).SELECT name, course_name FROM student WHERE age>50 and age <80;
need an explanation for this answer? contact us directly to get an explanation for this answer