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