Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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.