We’ve seen how to look only at certain columns of the table but it is often useful to only look at certain rows in a table. For example, we could want to look only at the bike trips which are at least a certain number of minutes. Let’s say you’re only interested in bike trips of 60 minutes or more:
It’s also possible to filter by multiple criteria. For example to look at only bike trips which are 60 minutes or more and only the subscriber type of Member:
9.4.1. Practice Exercises¶
select end_station, duration from trip_data where start_station = 31111 and duration > 8 * 60 * 60
select count(*) from trip_data where start_station = 31111 and duration > 8 * 60 * 60 and end_station = 31111
Figure out how to get all the trips on the bike with id of
and only include rides which are shorter than 15 minutes.
Get the ending station and the duration of all of the bike trips originating at station
31111 that lasted 8 hours or more.
How many trips longer than 8 hours started and ended and station 31111 by casual riders?
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