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!
Este exercício faz parte do curso
Window Functions in Snowflake
Instruções do exercício
- 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.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
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;