This lesson's interactive features are locked, please to keep using them

Select Multiple Columns

As you probably guessed, if you can select all columns with a *, and you can select a single column by name, you can also select multiple columns by name. For example, if I had a monsters table that stores their attributes, I might write:

select
  health,
  damage,
  defense
from
  monsters;

All SQL statements must end with a semicolon ;.

Assignment

Update the query to select the:

age
name
balance

columns in that order.

You can use the "Starter Tables" button in the code editor context menu to view the starter table:

You can use the toggle with table icon on the right of your screen to view the starter table: