CREATE TABLE Orders
(
  ordno varchar(4),
  mes varchar(3),
  cid varchar(4),
  Aid varchar(3),
  pid varchar(3),
  qty integer,
  dollars float
);

INSERT INTO Orders
(ordno,mes,cid,Aid,pid,qty,dollars)
VALUES
('1011','jan','c001','a01','p01',1000,450);

INSERT INTO Orders
(ordno,mes,cid,Aid,pid,qty,dollars)
VALUES
('1012','jan','c001','a01','p01',1000,450);

INSERT INTO Orders
(ordno,mes,cid,Aid,pid,qty,dollars)
VALUES
('1013','jan','c002','a03','p03',1000,880);

INSERT INTO Orders
(ordno,mes,cid,Aid,pid,qty,dollars)
VALUES
('1014','jan','c003','a03','p05',1200,1104);

INSERT INTO Orders
(ordno,mes,cid,Aid,pid,qty,dollars)
VALUES
('1015','jan','c003','a03','p05',1200,1104);