Was that a fast charge?
One of the unique experiences of owning an electric vehicle is charging. Depending on the location, time of day, and home-setup, the time is takes to charge an EV differs from owner-to-owner.
In this exercise, you'll evaluate the amount of time it takes for drivers to charge their EV's at specific charging stations using RANK.
Это упражнение является частью курса
Window Functions in Snowflake
Интерактивное практическое упражнение
Попробуйте выполнить это упражнение, дополнив этот пример кода.
SELECT
user_id,
charging_station_id,
charging_duration,
-- Rank records by charging duration
___() OVER(
___ ___ ___
) AS quickest_charges
FROM ELECTRIC_VEHICLES.charging
WHERE charging_station_id = 'Station_108';