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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the tuples having temperature greater than 'Paris'.

SELECT * FROM weather WHERE temperature > 'Paris' temperature
SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')

ANSWER DOWNLOAD EXAMIANS APP