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

Connected

Exercise

What burns more calories?

You're interesting in uncovering a bit of high-level information around workouts. Values like the total and average number of calories burned could provide insight to gym members who are looking to get the most out of their workouts. Luckily, you have the tools to do so!

Instructions

100 XP
  • Find the total sum of calories_burned for each workout_type.
  • Define a new column that stores the average number of calories_burned for each workout_type.
  • Create a column that stores the average number of calories_burned, rounded to two decimal places.
  • Aggregate the records by workout_type to ensure an error is not thrown.
Powered by Snowflake