Select customer columns
Return customer_id and name from every row in customers, in that column order. Keep duplicate names. Row order does not matter.
Difficulty: beginner
Show hint
Use SELECT to choose the two requested columns from customers.
Tables and sample data
Each test starts with fresh tables. Result rows may be returned in any order. Column names and column order must match.
| customer_id (integer) | name (text) | city (text) |
|---|---|---|
| 1 | Asha | Kathmandu |
| 2 | Ben | London |
| 3 | Chen | Singapore |
| customer_id | name |
|---|---|
| 1 | Asha |
| 2 | Ben |
| 3 | Chen |