Introduction
Practice
17. Exercise 16
Summary

Instruction

Finally! Here's the last exercise.

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.

Console

Code editor

Result

TableConsoleMap