Optimizing charging scheduling
Lucky for you, you've become the go-to Snowflake user for answering day-to-day questions about each charging station. Your operations team is interested in ranking each charge based on the duration, for each charging station. This will help them optimize scheduling blocks for their new app. Time to get to it!
This exercise is part of the course
Window Functions in Snowflake
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
charger_type,
charging_duration * 60 AS charging_minutes,
-- Assign a ranking to reach record based on charging
-- duration, from shortest to longest
___() ___(
-- Segment the result set by charger type
___ ___ ___
ORDER BY ___
) AS ___
FROM ELECTRIC_VEHICLES.charging;