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

Connected

अभ्यास

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>.

निर्देश

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