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

Connected

Exercise

Comparing senior workouts

Let's say you're interested in comparing workouts by senior gym members by gym location and workout type. To do this, you need to use three different tables, which could get a bit messy. Lucky for you, common table expressions can help to make this a breeze!

Instructions 1/3

undefined XP
    1
    2
    3
  • Create a temporary result set called senior_members that retrieves the user_id from the members table.