SELECT everything

A database holds tables; a table has named columns and any number of rows. SELECT * FROM products; asks for every column (*) of every row in the products table. The result is itself a table, shown below the editor when you run the query.

The practice database is a small shop: customers (id, name, city, joined), products (id, name, category, price, stock), orders (id, customer_id, product_id, quantity, ordered_at), and employees (id, name, dept, salary, manager_id). It is rebuilt before every run, so nothing you do can break it.

Keywords like SELECT and FROM are not case-sensitive, but writing them in capitals is the convention and makes queries easier to read. A semicolon ends a statement.

SELECT * FROM employees;

Your task

Show every column of every row in the products table.

SELECT * FROM products;