1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Redshift
Connected

Exercise

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.

Instructions

100 XP
  • 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.