SELECT columns: customer names and cities

Laras, the operations manager, is choosing a new courier service. She asks for a customer list with only names and cities, so she can easily see which cities the courier must reach. Other columns such as email and join date are not needed.

Task

Show only two columns from the customers table, in exactly this order: name, then city. All 24 customers are included. Any row order is fine.

Databasetokotables & columns are listed in the right panel

Required keywordsSELECT

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Run previewCtrlEnter
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
Replace the * with the names of the columns you want to show.
Hint 2
Separate several columns with commas: SELECT column1, column2. The order you write them in sets the order of the result columns.
Hint 3
The pattern is SELECT ___, ___ FROM customers;

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

SELECT name, city
FROM customers;

Explanation

SELECT name, city picks two columns, so only those appear, in the order written. There are still 24 rows because nothing has been filtered yet. Picking columns only trims the table sideways, not downwards.
Common mistakes:

Forgetting the comma between column names. SELECT name city does not fail, but it is read as the name column with the new header city! (A new header like that is called an alias, the topic of the next exercise.)
Misspelling a column name. If you get a "no such column" error, check the table's column list again.

SQL· database toko

SELECT *
FROM customers;

Loading the SQL editor…

Write the SQL query, run it to see the result, then press Check answer.

Validation result