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!
This exercise is part of the course
Window Functions in Snowflake
Exercise instructions
- 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.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
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;