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!
Diese Übung ist Teil des Kurses
Data Types and Functions in Snowflake
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Create a senior_members temporary result set
___ ___ ___ (
SELECT
___
FROM CORE_GYM.members
WHERE personal_info:age::NUMBER > 60
)
SELECT * FROM senior_members;