SELECT *: view the whole customers table

Intan has just joined Kedai Nusantara, an online coffee and snack shop, as a data analyst. All of the shop's data lives in a database, which is a collection of tables. A table is like an Excel sheet: each column holds one kind of detail (such as a name or a city), and each row is one complete record (here: one customer).
On her first day, Intan wants to look at the customers table before doing anything else.

Task

Write a query (a command that reads data) that shows every column and every row of the customers table. The result has 24 rows and 6 columns: customer_id, name, city, segment, join_date, email. 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
A query that reads data starts with SELECT (which columns to show), followed by FROM (which table).
Hint 2
An asterisk * after SELECT means "all columns". End the query with a semicolon ;.
Hint 3
The pattern is SELECT * FROM table_name;. Replace table_name with the name of the customers table.

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 *
FROM customers;

Explanation

SELECT * means "take every column", and FROM customers names the source table. The result is the whole table: 24 customers, one row each, with 6 columns.
Things to remember:

SQL keywords such as SELECT and FROM can be written in lowercase, but uppercase makes a query easier to read.
A query can be on one line or several lines. Spaces and line breaks do not change the result.
The table name must be exact: customer (without the s) raises a "no such table" error.
Lines in the editor that start with -- are comments: notes for humans that the database ignores.
The email column contains NULL values, meaning that customer has not given an email yet. We will deal with that in a later exercise.

SELECT * is handy for getting to know a table. For reports we usually pick specific columns. That is the next exercise.

SQL· database toko

-- Lines that start with two minus signs are comments and are not run.
-- Write your query below this line.

Loading the SQL editor…

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

Validation result