-- create table
create table Cake ( id integer not null, name text, price real );
create table Drink ( id integer primary key, name text );

-- insert ...
insert into Cake values (7, 'Victoria sponge', 3.2);

-- show tables
.tables