CREATE TABLE

CREATE TABLE reviews (id INTEGER PRIMARY KEY, product_id INTEGER NOT NULL, rating INTEGER NOT NULL, comment TEXT); defines a table with its columns and their types. INTEGER PRIMARY KEY makes an auto-numbered identifier; NOT NULL refuses missing values; TEXT, INTEGER, and REAL are the common types. REFERENCES products(id) on a column declares a foreign key.

Statements run one after another, so a CREATE TABLE followed by an INSERT into it works in a single run.

CREATE TABLE tags (id INTEGER PRIMARY KEY, label TEXT NOT NULL);
INSERT INTO tags (label) VALUES ('sale');

Your task

Create a reviews table with columns id (integer primary key), product_id (integer, not null), rating (integer, not null), and comment (text). Then insert one review for product 1 with rating 5 and the comment Great keys.

CREATE TABLE reviews (
  id INTEGER PRIMARY KEY,
  product_id INTEGER NOT NULL,
  rating INTEGER NOT NULL,
  comment TEXT
);

INSERT INTO reviews (product_id, rating, comment) VALUES (1, 5, 'Great keys');