Visualizing charging session duration and cost

SELECT
    charging_station_location,
    TO_DATE(charging_start_time) AS charging_date,
    charging_duration,
    charging_cost,
	
    -- Find the proportion of total charging duration charging location
    charging_duration / ___(___) OVER(
        PARTITION BY ___
    ) AS proportion_of_daily_charging_duration,
	
    -- Determine the difference between each session's charging 
    -- cost and the average charging cost for each charging station location
    charging_cost - ___(___) OVER (
        PARTITION BY ___
    ) AS ___

FROM ELECTRIC_VEHICLES.charging

-- Order the results by charging station location and charging date
ORDER BY ___, ___;