Introduction to SQL
Find the name of cities with all entries whose temperature is in the range of 71 and 89

SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;
SELECT * FROM weather WHERE temperature NOT IN (71 to 89);
SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
SELECT * FROM weather WHERE temperature NOT IN (71 and 89);

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 WHERE age<80;
SELECT name, course_name FROM student WHERE age>50 and <80;
SELECT name, course_name FROM student WHERE age>50 and age <80;

ANSWER DOWNLOAD EXAMIANS APP