1. Learn
  2. /
  3. Courses
  4. /
  5. Window Functions in Snowflake

Connected

Exercise

Comparing energy consumed

Being able to compare records to summary metrics is one of the most powerful use cases for window functions. In this exercise, you'll build two window functions to compare each record to the minimum and maximum energy consumed.

Instructions 1/2

undefined XP
    1
    2
  • Create a column called least_energy_consumed to find the minimum energy consumed in a charging session.