1. सीखें
  2. /
  3. पाठ्यक्रम
  4. /
  5. Data Types and Functions in Snowflake

Connected

अभ्यास

Making appointments

Sometimes, a gym member will have a visit with a personal trainer. These visits must be booked in advanced to make sure a specific trainer is available. At the end of a visit with a trainer, the gym's "welcome team" will work with the member to set up another appointment, and you'd like to make their lives a little easier by suggesting next-appointment times.

निर्देश

100 XP
  • Create a new column called in_one_week that proposes a next-appointment with a trainer in one week from the checkin_time TIMESTAMP.
  • Repeat the first step, but this time, for an appointment in two weeks from the checkin_time.
  • Define one last column that proposes a next-appointment in one month from the checkin_time, and name the column in_one_month.
Powered by Snowflake