Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.
The order of occurrence determines the order of evaluation.
NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.
NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query is correct for using comparison operators in SQL?

None of these
SELECT name, course_name FROM student WHERE age>50 and <80;
SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;
SELECT name, course_name FROM student WHERE age>50 and age <80;

ANSWER DOWNLOAD EXAMIANS APP