9.6. Sorting

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 criteria.

For example, to see the bike trips in the order of the duration in seconds:

SELECT member_type, start_date, duration FROM trip_data ORDER BY duration LIMIT 10

Well, it turns out by default the sorting order is ascending. To sort the rows in descending order, add the keyword DESC.

SELECT member_type, start_date, duration FROM trip_data ORDER BY duration DESC LIMIT 10

Of course, we can mix WHERE and ORDER BY, to get only the bike trips from Member type of Casual in the order of the duration.

SELECT member_type, start_date, duration FROM trip_data WHERE member_type = "Casual" ORDER BY duration LIMIT 10

9.6.1. Practice Exercises

SELECT duration, start_station, end_station FROM trip_data WHERE duration >= 3600 ORDER BY duration DESC LIMIT 40

2. select bike_number, duration from trip_data order by duration desc limit 1;

3. 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.

==== assert 39,0 == 84190 assert 39,2 == 31018

On which bike was longest bike ride? How many seconds long was that ride?

==== assert 0,0 == W00379 assert 0,1 == 86355

What is the starting station and duration of the longest ride starting and ending at the same station?

==== assert 0,1 == 86337 assert 0,0 == 31221

Lesson Feedback

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

Before you keep reading...

Runestone Academy can only continue if we get support from individuals like you. As a student you are well aware of the high cost of textbooks. Our mission is to provide great books to you for free, but we ask that you consider a $10 donation, more if you can or less if $10 is a burden.

Support Runestone Academy Today

Before you keep reading...

Making great stuff takes time and $$. If you appreciate the book you are reading now and want to keep quality materials free for other students please consider a donation to Runestone Academy. We ask that you consider a $10 donation, but if you can give more thats great, if $10 is too much for your budget we would be happy with whatever you can afford as a show of support.

Support Runestone Academy Today

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

You have attempted 1 of 13 activities on this page