LoslegenKostenlos loslegen

Creating your own Snowflake function

The development team is back again, thanks to all of your hard work from before. They'd like to create a "leader board" in the application to rank gym members by the efficiency of their workouts. Efficiency is determined by the number of calories that are burned per minute of working out. The first step to provide this data is creating a function to determine efficiency. Good luck!

Diese Übung ist Teil des Kurses

Data Types and Functions in Snowflake

Kurs anzeigen

Anleitung zur Übung

  • Define a function called calories_per_minute with three parameters: start_time and end_time, which are both of the type TIMESTAMP, and calories_burned, which is a NUMBER.
  • Further update the calories_per_minute function to return a NUMBER.
  • Use the DATEDIFF function to find the number of minutes between the check-in and checkout timestamps and divide by the number of calories_burned to determine workout efficiency.

Interaktive Übung

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

-- calories_per_minute should take a start_time, end_time, and calories_burned
CREATE OR REPLACE FUNCTION ___(
    ___ TIMESTAMP, ___ ___, calories_burned ___
)

-- Make sure the function returns a NUMBER
RETURNS ___

AS

$$
-- Use DATEDIFF to calculate the efficiency of a workout
___(MINUTE, start_time, end_time) / calories_burned
$$;
Code bearbeiten und ausführen