Challenge: Total Ride Time for Each Subway LineChallenge: Total Ride Time for Each Subway Line

Note

SUM(column) is the function returns the sum of the values in a specific colum.

Task

Calculate the total ride time for each subway line by creating a new column called total_time using the time_to_next_station values and the SUM() function. Following that, arrange the outcome in ascending order using the total_time column.

Here's a short example of the relation table:

relation_idline_namestation_nametime_to_next_station
1GreenAngrignon10
2GreenMonk16
3GreenVerdun9
............
21YellowLongueuil10

Everything was clear?

Section 1. Chapter 3
toggle bottom row