Extracting date parts

There is some concern about whether an anemometer measuring wind speed was properly repaired at the Coffee County weather station. It was suggested that the number of windy readings in each month be compared to see if it was repaired by October 2023.

Deze oefening maakt deel uit van de cursus

Introduction to Redshift

Cursus bekijken

Oefeninstructies

Get the year from the date column, aliasing as year.
Get the month from the date column, aliasing as month.
Only count them when the hourlywindspeed is not '0' by returning the number 1'.
Group and order by the year and month, in that order.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

-- Get the year from date as year
SELECT ___(___, date) as year,
       -- Get the month from date as month
       ___(___, ___) as ___,
       -- Count readings when the hourlywindspeed isn't '0'
       COUNT(
           CASE WHEN ___ != '0' THEN ___
           ELSE NULL
           END
       )
  FROM public_intro_redshift.coffee_county_weather
 -- Group and order by the dateparts you extracted
 GROUP BY ___, ___
 ORDER BY ___ DESC, ___ DESC;

Code bewerken en uitvoeren