1. Học hỏi
  2. /
  3. Khoa Học
  4. /
  5. Window Functions in Snowflake

Connected

Bài tập

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.

Hướng dẫn 1/2

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