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!
Diese Übung ist Teil des Kurses
<Kurs>Window Functions in Snowflake</Kurs>Interaktive praktische Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
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;