Introduction
Geometry vs. Geography
Summary

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.

Console

Code editor

Result

TableConsoleMap