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

SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')
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 > 'Paris' temperature

ANSWER DOWNLOAD EXAMIANS APP

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

SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
SELECT city, temperature, humidity, country FROM location;
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;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

ANSWER DOWNLOAD EXAMIANS APP