WHERE 子句

SELECT_clause FROM_clause WHERE <conditional_expression> [(AND|OR) <conditional_expression> [...]]

SELECT * 
FROM "h2o_feet" 
WHERE "water_level" >= 9.78

SELECT * 
FROM "h2o_feet" 
WHERE "location" = 'santa_monica' and "level description" = 'below 3 feet' 

SELECT *
FROM h2o_feet 
WHERE "location" = 'santa_monica'
AND "time" >= '2019-08-19T12:00:00Z' AND "time" <= '2019-08-19T13:00:00Z'

SELECT *
FROM h2o_feet 
WHERE "location" = 'santa_monica'
  AND time >= DATE_TRUNC('day', NOW() - INTERVAL '1 day') 
  AND time < DATE_TRUNC('day', NOW())

SELECT *
FROM h2o_feet 
WHERE time >= NOW() - INTERVAL '1 day' AND location = 'santa_monica'

SELECT *
FROM h2o_feet 
WHERE time >= DATE_TRUNC('week', NOW()) AND location = 'santa_monica'

SELECT *
FROM "h2o_feet"
WHERE "level description" = 'less than 3 feet' OR "water_level" < 2.5