text: CREATE DATABASE orders;
  
  CREATE TABLE agents (
    agent_code TEXT PRIMARY KEY,
    agent_name TEXT,
    working_area TEXT,
    commission MONEY,
    phone_no TEXT
  );
  
  CREATE TABLE orders (
    ord_num SERIAL PRIMARY KEY,
    ord_amount MONEY,
    advance_amount MONEY,
    ord_date TEXT,
    cust_code TEXT,
    agent_code TEXT REFERENCES agents (agent_code)
  );
  
  INSERT INTO agents (agent_code, agent_name, working_area, commission, phone_no) VALUES
    ('A007', 'Ramasundar', 'Bangalore', 0.15, '077-25814763'),
    ('A003', 'Alex', 'London', 0.13, '075-12458969'),
    ('A008', 'Alford', 'New York', 0.12, '044-25874365'),
    ('A011', 'Ravi Kumar', 'Bangalore', 0.15, '077-45625874'),
    ('A010', 'Santakumar', 'Chennai', 0.14, '007-22388644'),
    ('A012', 'Lucida', 'San Jose', 0.12, '044-52981425'),
    ('A005', 'Anderson', 'Brisban', 0.13, '045-21447739'),
    ('A001', 'Subbarao', 'Bangalore', 0.14, '077-12346674'),
    ('A002', 'Mukesh', 'Mumbai', 0.11, '029-12358964'),
    ('A006', 'McDen', 'London', 0.15, '078-22255588'),
    ('A004', 'Ivan', 'Torento', 0.15, '008-22544166'),
    ('A009', 'Benjamin', 'Hampshair', 0.11, '008-22536178');
  
  INSERT INTO orders (ord_num, ord_amount, advance_amount, ord_date, cust_code, agent_code) VALUES
    (200114, 3500, 2000, '15-AUG-08', 'C00002', 'A008'),
    (200122, 2500, 400, '16-SEP-08', 'C00003', 'A004'),
    (200118, 500, 100, '20-JUL-08', 'C00023', 'A006'),
    (200119, 4000, 700, '16-SEP-08', 'C00007', 'A010'),
    (200121, 1500, 600, '23-SEP-08', 'C00008', 'A004'),
    (200130, 2500, 400, '30-JUL-08', 'C00025', 'A011'),
    (200134, 4200, 1800, '25-SEP-08', 'C00004', 'A005'),
    (200108, 4000, 600, '15-FEB-08', 'C00008', 'A004'),
    (200103, 1500, 700, '15-MAY-08', 'C00021', 'A005'),
    (200105, 2500, 500, '18-JUL-08', 'C00025', 'A011'),
    (200109, 3500, 800, '30-JUL-08', 'C00011', 'A010'),
    (200101, 3000, 1000, '15-JUL-08', 'C00001', 'A008'),
    (200111, 1000, 300, '10-JUL-08', 'C00020', 'A008'),
    (200104, 1500, 500, '13-MAR-08', 'C00006', 'A004'),
    (200106, 2500, 700, '20-APR-08', 'C00005', 'A002'),
    (200125, 2000, 600, '10-OCT-08', 'C00018', 'A005'),
    (200117, 800, 200, '20-OCT-08', 'C00014', 'A001'),
    (200123, 500, 100, '16-SEP-08', 'C00022', 'A002'),
    (200120, 500, 100, '20-JUL-08', 'C00009', 'A002'),
    (200116, 500, 100, '13-JUL-08', 'C00010', 'A009'),
    (200124, 500, 100, '20-JUN-08', 'C00017', 'A007'),
    (200126, 500, 100, '24-JUN-08', 'C00022', 'A002'),
    (200129, 2500, 500, '20-JUL-08', 'C00024', 'A006'),
    (200127, 2500, 400, '20-JUL-08', 'C00015', 'A003'),
    (200128, 3500, 1500, '20-JUL-08', 'C00009', 'A002'),
    (200135, 2000, 800, '16-SEP-08', 'C00007', 'A010'),
    (200131, 900, 150, '26-AUG-08', 'C00012', 'A012'),
    (200133, 1200, 400, '29-JUN-08', 'C00009', 'A002'),
    (200100, 1000, 600, '08-JAN-08', 'C00015', 'A003'),
    (200110, 3000, 500, '15-APR-08', 'C00019', 'A010'),
    (200107, 4500, 900, '30-AUG-08', 'C00007', 'A010'),
    (200112, 2000, 400, '30-MAY-08', 'C00016', 'A007'),
    (200113, 4000, 600, '10-JUN-08', 'C00022', 'A002'),
    (200102, 2000, 300, '25-MAY-08', 'C00012', 'A012');
  
  