msAVsJZw

1CREATE TABLE if not exists store
2( id serial,
3  sname varchar(40) not null,
4  qty integer not null,
5  price float not null, primary key (id));
6
7INSERT INTO store (sname, qty, price)
8VALUES ('apple', 10, 1), ('pear', 5, 2), ('banana', 10, 1.5), ('lemon', 100, 0.1), ('orange', 50, 0.2);