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.
Это упражнение является частью курса
Window Functions in Snowflake
Интерактивное практическое упражнение
Попробуйте выполнить это упражнение, дополнив этот пример кода.
SELECT
user_id,
charging_station_location,
charger_type,
energy_consumed,
-- Find the least energy consumed in a charging session
___(___) OVER(
ORDER BY ___
) AS least_energy_consumed
FROM ELECTRIC_VEHICLES.charging;