Engaging vehicle owners with metrics
To better engage vehicle owners, the marketing team is currently using two tables to send a post-charge message comparing that user's session to their vehicle model's average. They'd like to streamline this process, so they've come to you. Time to show them what you're made of!
Это упражнение является частью курса
Window Functions in Snowflake
Интерактивное практическое упражнение
Попробуйте выполнить это упражнение, дополнив этот пример кода.
SELECT
user_id,
vehicle_model,
energy_consumed,
charging_duration,
-- Count the total number of charging sessions by vehicle_model
___(*) OVER(
PARTITION BY ___
) AS total_number_of_charges
FROM ELECTRIC_VEHICLES.charging
ORDER BY vehicle_model;