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

Introduction to SQL
Find the temperature in increasing order of all cities

SELECT city FROM weather ORDER BY temperature;
SELECT city, temperature FROM weather ORDER BY city;
SELECT city, temperature FROM weather ORDER BY temperature;
SELECT city, temperature FROM weather;

ANSWER DOWNLOAD EXAMIANS APP