LoslegenKostenlos starten

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!

Diese Übung ist Teil des Kurses

<Kurs>Data Types and Functions in Snowflake</Kurs>
Kurs ansehen

Übungsanweisungen

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

Interaktive praktische Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

SELECT
    user_id,
    gym_id,
    checkin_time,

	-- Determine workout efficiency for each user using the check in/out
    -- time, as well as the number of calories burned
    ___(
        ___, 
        ___, 
        ___
    ) AS ___  -- Alias the results as workout_efficiency

FROM CORE_GYM.visits

-- Order the results by workout_efficiency
___ ___ ___ DESC;
Code bearbeiten und ausführen