1.12. SQL

You can even have SQL in an activecode.

select bike_number, max(duration) from trip_data where start_station = 31105 group by bike_number order by max(duration) desc limit 4; ==== assert 0,0 == W00554 assert 0,1 == 51618 assert 2,1 == 38347

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

.. activecode:: sql1
   :language: sql
   :autograde: unittest
   :dburl: /_static/bikeshare.db

   select bike_number, max(duration)
   from trip_data
   group by bike_number
   order by max(duration) desc
   limit 4;

   ====
   assert 0,0 == W00379
   assert 0,1 == 86355
   assert 2,1 == 86336

You have attempted 1 of 3 activities on this page