2. Nested Subqueries
Challenge: The Shortest Ride of Each Subway Line
MIN(column)this function returns the smallest value in a particular column.
LIMITclause help you to get certain number of rows.
You have to find the shortest trip (create a new column, named
MIN() function) of each subway line (
line_name column). Order it by the
min_time column in ascending order and print the first three rows.
Here's a short example of the
Everything was clear?