Exercise

How long were you at the gym?

Let's say that you're interested in how long each member was at the gym for. This would help to give you and the other teams consuming data from Snowflake the ability to understand things like workout efficiency. To do this, you'll have to use one of Snowflake's powerful date functions - good luck!

Instructions

100 XP

In the SELECT statement, retrieve the user_id field, as well as the check in/out columns.
Use a Snowflake function to find the difference between the checkin_time and checkout_time, making sure the value returned is in minutes.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise