Evaluating charging duration
To help provide better information in their app, the development team wants to include a banner on the landing page that says something like "X% of vehicles owners charge in less than Y minutes". To do this, they need to understand the distribution of charging time at each charging station. That's where you come in!
Deze oefening maakt deel uit van de cursus
Window Functions in Snowflake
Oefeninstructies
- Update the
SELECTstatement to include a window function that finds the cumulative distribution of records in the results set. - "Segment" records by the
charging_station_id, such that a cumulative distribution is created for each. - Make sure the cumulative distribution generated by the
charging_duration, in ascending order.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT
user_id,
charging_station_id,
charging_duration * 60,
-- Find the cumulative distribution of records in the result set
___ ___(
-- Segment records by charging station id
___
-- Create the cumulative distribution using charging duration
___
) AS charging_duration_dist
FROM ELECTRIC_VEHICLES.charging
ORDER BY charging_station_id, charging_duration_dist;