SQL Basics 02. WHERE. Database: WEATHER_STATIONS. SQLite.

Database: WEATHER_STATIONS

Table: STATION_DATA

CREATE TABLE STATION_DATA (

station_number INTEGER,

report_code VARCHAR,

year INTEGER,

month INTEGER,

day INTEGER,

dew_point DECIMAL,

station_pressure DECIMAL,

visibility DECIMAL,

wind_speed DECIMAL,

temperature DECIMAL,

precipitation DECIMAL,

snow_depth DECIMAL,

fog BOOLEAN,

rain BOOLEAN,

hail BOOLEAN,

thunder BOOLEAN,

tornado BOOLEAN

);

WHERE

Query 1

SELECT

*

FROM STATION_DATA;

Query 2

SELECT

*

FROM STATION_DATA

WHERE

(YEAR = 2002 OR YEAR = 2003)

AND MONTH IN (5,6,7,8)

AND DAY >=1 AND DAY <= 30

AND PRECIPITATION >0

;

Query 3

SELECT

*

FROM STATION_DATA

WHERE

STATION_NUMBER LIKE '1%'

AND YEAR = 1999

AND MONTH = 1

;

Query 4

SELECT

*

FROM STATION_DATA

WHERE

(STATION_NUMBER LIKE '123___'

OR STATION_NUMBER LIKE '___567')

AND YEAR >= 1980 AND YEAR <= 2000

;

Query 5

SELECT

*

FROM STATION_DATA

WHERE

YEAR >= 1980 AND YEAR <= 2000

AND DEW_POINT IS NOT NULL

AND coalesce(STATION_PRESSURE, 0) >=1000

;