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.
Den här övningen är en del av kursen
Window Functions in Snowflake
Interaktiv övning med praktiskt arbete
Testa den här övningen genom att slutföra den här exempelkoden.
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';