ComeçarComece de graça

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!

Este exercício faz parte do curso

Data Types and Functions in Snowflake

Ver curso

Instruções do exercício

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

Exercício interativo prático

Experimente este exercício completando este código de exemplo.

-- 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
$$;
Editar e executar o código