Introduction
Geometry vs. Geography
Instruction
Before we start, you'll need to familiarize yourself with the very last table of our database: usa_states.
Exercise
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.
