INTRODUCTION TO SQL QUIZ

SELECT city, temperature, humidity, country FROM location;

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

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

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

False

True

Dates

Column Alias

Strings

All of these

All of these

FLOAT

NUMERIC

CHARACTER

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

False

True

SORT

ORDER

SORT BY

ORDER BY

for ranges.

None of these

as a wildcard.

to limit the columns displayed.

False

True

SELECT

JOIN

INSERT

DELETE