Introduction to SQL
The SQL -92 wildcards are ____ and ____ .

question mark (?); asterisk (*)
percent sign (%); underscore (_)
underscore(_); question mark (?)
asterisk (*); percent sign (%)

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;
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;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the names of the countries whose condition is sunny.

SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');
SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');
SELECT country FROM location WHERE condition = 'sunny';
SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');

ANSWER DOWNLOAD EXAMIANS APP