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.
Este exercicio faz parte do curso
Window Functions in Snowflake
exercicio interativo prático
Tente este exercicio completando este código de exemplo.
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';