CREATE TABLE Products
(
  pid VARCHAR(4),
  pname VARCHAR(30),
  city VARCHAR(30),
  quantity FLOAT,
  price FLOAT
);

INSERT INTO Products
(pid,pname,city,quantity,price)
VALUES
('p01','comb','Dallas',111.400,0.5);

INSERT INTO Products
(pid,pname,city,quantity,price)
VALUES
('p02','brush','Newark',203.000,0.5);

INSERT INTO Products
(pid,pname,city,quantity,price)
VALUES
('p03','razor','Duluth',150.600,1);

INSERT INTO Products
(pid,pname,city,quantity,price)
VALUES
('p04','pen','Duluth',125.300,1);

INSERT INTO Products
(pid,pname,city,quantity,price)
VALUES
('p05','pencil','Dallas',221.400,1);

INSERT INTO Products
(pid,pname,city,quantity,price)
VALUES
('p06','folder','Dallas',123.100,2);

INSERT INTO Products
(pid,pname,city,quantity,price)
VALUES
('p07','case','Newark',100.500,1);