Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
17. Exercise 16


Finally! Here's the last exercise.


Mark's trip was a success. However, it's been a long day, and he would now like to return to his apartment in the Mission district. Find all bicycle routes that link the Buena Vista and Mission districts.

Show the course column only.

Stuck? Here's a hint!

This is a tricky one! To retrieve only these routes that intersect with both of these districts you'll have to join the sf_bicycle_routes and sf_planning_districts...twice!

First you check whether a given route intersects with the Mission district, and then check whether a given route also intersects with the Buena Vista district.