--在庫マスタ
    CREATE TABLE stock_m (
        stock_id VARCHAR(5),
        goods_id VARCHAR(10),
        arrival_date DATE,
        arrival_num INT,
        security_num INT,
    PRIMARY KEY (stock_id, goods_id, arrival_date)
    );
    
--レコード
    INSERT INTO stock_m VALUES
        ('W0001','ITM0000001','2012-08-24',2,2),
        ('W0001','ITM0000001','2012-12-25',3,3),
        ('W0001','ITM0000001','2013-06-01',2,2),
        ('W0001','ITM0000001','2013-11-20',5,4),
        ('W0001','ITM0000001','2014-08-06',7,0),
        ('W0001','ITM0000002','2014-03-04',100,100),
        ('W0001','ITM0000002','2014-09-05',50,45),
        ('W0001','ITM0000002','2014-09-10',60,0),
        ('W0001','ITM0000003','2013-09-17',5,2),
        ('W0001','ITM0000004','2010-03-03',10,10),
        ('W0001','ITM0000004','2012-10-05',3,3),
        ('W0001','ITM0000004','2013-09-10',6,5),
        ('W0001','ITM0000004','2014-04-03',2,0),
        ('W0001','ITM0000005','2014-04-28',150,150),
        ('W0001','ITM0000005','2014-05-20',100,86);