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 probably also select multiple columns by name. Here's the syntax:

select column_one, column_two, column_three from table_name;

For example, if I had a table of monster records for a game, 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 toggle with table icon on the right of your screen to view the starter table: