So far, we’ve only looked at rows of data in the order of the query is
returning to us. What if we want to see the rows in a certain sorting
order? We use the
ORDER BY command to sort them by some other
For example, to see the bike trips in the order of the duration in seconds:
Well, it turns out by default the sorting order is ascending. To
sort the rows in descending order, add the keyword
Of course, we can mix
ORDER BY, to get only the bike
trips from Member type of Casual in the order of the duration.
9.5.1. Practice Exercises¶
select bike_number, duration from trip_data order by duration desc limit 1;
select start_station, duration from trip_data where start_station = end_station order by duration desc limit 1;
Get the duration, start station ID, and end station ID for bike trips that are 60 minutes or longer, in the order of largest number of seconds first and display the top 40 results.
On which bike was longest bike ride? How many seconds long was that ride?
What is the starting station and duration of the longest ride starting and ending at the same station?
During this lesson I was primarily in my...
- 1. Comfort Zone
- 2. Learning Zone
- 3. Panic Zone
Completing this lesson took...
- 1. Very little time
- 2. A reasonable amount of time
- 3. More time than is reasonable
Based on my own interests and needs, the things taught in this lesson...
- 1. Don't seem worth learning
- 2. May be worth learning
- 3. Are definitely worth learning
For me to master the things taught in this lesson feels...
- 1. Definitely within reach
- 2. Within reach if I try my hardest
- 3. Out of reach no matter how hard I try