Tables (CREATE & INSERT)
Defining tables with CREATE TABLE and inserting data with INSERT.
Simple enough for a 5-year-old to understand
Create table and insert data
CREATE TABLE item (id INTEGER, name TEXT, price REAL);INSERT INTO item VALUES (1, 'Pencil', 5.5);INSERT INTO item VALUES (2, 'Notebook', 12.0);SELECT COUNT(*) FROM item;