1. Learn
  2. /
  3. Courses
  4. /
  5. Data Types and Functions in Snowflake

Connected

Exercise

Motivating member marketing

As part of a new effort to motivate gym members to come back, the marketing team is interested in creating notifications to share with members after a workout. Your job is to automate the creation of these messages so it can be quickly integrated into their app.

The message should look something like this: On <date> you burned <calories burned> calories via <workout type>.

Instructions

100 XP
  • Use the appropriate function to join several text values together into a single message.
  • Add the calories_burned from the visits table to the message.
  • Include the workout_type the member performed during their visit to the message, then alias the result as message.
Powered by Snowflake