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.
Acest exercițiu face parte din cursul
Window Functions in Snowflake
Exercițiu interactiv practic
Încearcă acest exercițiu completând acest cod de exemplu.
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';