Find future dates

When doing some research, you discover that Coffee County hit a low humidity of 10 on '2023-01-15 15:35:00'. The field staff would like a query with the date and hourlystationpressure listed, 30 days prior, 30 days later, and 90 days later.

Latihan ini adalah bagian dari kursus

Introduction to Redshift

Lihat Kursus

Petunjuk latihan

Select the date and the hourlystationpressure for '2023-01-15 15:35:00', 30 days prior, 30 days later, and 90 days later.
Build a proper IN clause list using DATEADD functions to get 30 days prior, 30 days later and 90 days later.

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

SELECT date, 
       hourlystationpressure
  FROM public_intro_redshift.coffee_county_weather
 WHERE ___ IN (
           '2023-01-15 15:35:00', 
           -- 30 days prior
           ___(___, ___, '2023-01-15 15:35:00'), 
           -- 30 days later
           ___(___, ___, '2023-01-15 15:35:00'), 
           -- 90 days later
           ___(___, ___, '2023-01-15 15:35:00')
       )
 ORDER BY date;

Edit dan Jalankan Kode