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.
Cet exercice fait partie du cours
<cours>Window Functions in Snowflake</cours>Exercice interactif pratique
Essayez cet exercice en complétant ce code d’exemple.
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';