ćwiczenie

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!

Instrukcje

100 XP

Update the SELECT statement 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.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}ćwiczenie

Instrukcje

ćwiczenie