1. 学习
    2. /
  2. 课程
    3. /
  3. Introduction to Redshift
Connected

练习

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.

说明

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.