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!
Geometry vs. Geography


Before we start, you'll need to familiarize yourself with the very last table of our database: usa_states.


Select all information from table usa_states.

This table stores basic information about US states. Each state has a unique id, name, boundaries (a geography column), capital and capital_coordinates (another geography column). That's all we need for this part. You may want to take a look at the map tab to view the US states with their capitals marked.

Stuck? Here's a hint!

Use * to retrieve all rows and columns.