Exercise

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.

Instructions

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.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise