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

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of all cities with their temperature, humidity and countries.

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;
SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
SELECT weather.city, temperature, humidity, country FROM weather, location;
SELECT city, temperature, humidity, country FROM location;

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP