-- insert into product values(pid,pname,category,price);
-- category: clothing, movies, electronics, sports, jewelry
-- pname
-- clothing: shirt, skirt, jean, sweater, shoes
-- movies: romance,action,drama,horror,comedy
-- electronics: camera,camcorder,television,computer,phone
-- sports: bike, foosball, tent, archery, paintball
-- jewelry: ring, earring, bracelet, chain, pendant

insert into product values(1,'shirt','clothing',15);
insert into product values(2,'skirt','clothing',18);
insert into product values(3,'jean','clothing',20);
insert into product values(4,'sweater','clothing',25);
insert into product values(5,'shoes','clothing',25);
insert into product values(6,'romance','movies',5);
insert into product values(7,'action','movies',7);
insert into product values(8,'drama','movies',10);
insert into product values(9,'horror','movies',5);
insert into product values(10,'comedy','movies',9);
insert into product values(11,'camera','electronics',150);
insert into product values(12,'camcorder','electronics',650);
insert into product values(13,'television','electronics',250);
insert into product values(14,'computer','electronics',500);
insert into product values(15,'phone','electronics',50);
insert into product values(16,'bike','sports',35);
insert into product values(17,'foosball','sports',55);
insert into product values(18,'tent','sports',95);
insert into product values(19,'archery','sports',75);
insert into product values(20,'paintball','sports',35);
insert into product values(21,'ring','jewelry',55);
insert into product values(22,'earring','jewelry',45);
insert into product values(23,'bracelet','jewelry',85);
insert into product values(24,'chain','jewelry',105);
insert into product values(25,'pendant','jewelry',75);
