Lọc dữ liệu với CTE

-- Build a CTE named december_reading
___ ___ ___ (
    SELECT date,
           hourlydrybulbtemperature AS air_temp,
           report_type
      FROM public_intro_redshift.coffee_county_weather
     -- Date is in December using between syntax
     WHERE date ___ '2023-12-01' AND '2024-12-31'
)
SELECT date,
       air_temp
  -- From the CTE
  FROM ___
 -- For the FM-15 report type
 WHERE ___ = 'FM-15';