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

Connected

Exercise

Ranking gym members by efficiency

Now that you've created the calories_per_minute function, it's time to create the dataset for your development team. This is really going to put their app over the top!

Instructions

100 XP
  • Using the calories_per_minute function, determine the workout efficiency for each individual gym member using the visits table.
  • Alias the resulting column as workout_efficiency.
  • Sort the result set by workout_efficiency.
Powered by Snowflake