Slide 29
Slide 29 text
SELECT
COUNT(*) FILTER (WHERE PRCP BETWEEN 0.1 AND 0.2) low_days,
AVG(TMAX) FILTER (WHERE PRCP BETWEEN 0.1 AND 0.2) low_prcp_temp,
COUNT(*) FILTER (WHERE 0.4 < PRCP) high_days,
AVG(TMAX) FILTER (WHERE 0.4 < PRCP) high_prcp_temp
FROM R2Weather;