--2.1
    CREATE VIEW goods_stock_v AS
    SELECT
        goods_m.goods_id,
        goods_m.goods_nm,
        SUM(stock_m.arrival_num - stock_m.security_num) AS stock_num
    FROM goods_m
    INNER JOIN stock_m
    ON goods_m.goods_id = stock_m.goods_id
    GROUP BY
        goods_m.goods_id,
        goods_m.goods_nm;
        
    CREATE VIEW user_credit_v AS
    SELECT
        user_m.user_id,
        user_m.user_f_nm,
        user_m.user_nm,
        gender_m.gender_div_nm,
        user_m.mail_address,
        credit_card_t.credit_div_cd,
        credit_card_t.credit_no,
        credit_card_t.credit_nm
    FROM user_m
    LEFT JOIN credit_card_t
    ON user_m.user_id = credit_card_t.user_id
    LEFT JOIN gender_m
    ON user_m.gender_cd = gender_m.gender_cd;
    
    CREATE VIEW ins_stock_schedule_v AS
    SELECT
        ins_stock_m.goods_id,
        goods_m.goods_nm,
        ins_stock_m.ins_stock_exp_date,
        ins_stock_m.store_id,
        store_m.store_nm
    FROM ins_stock_m
    INNER JOIN goods_m
    ON ins_stock_m.goods_id = goods_m.goods_id
    INNER JOIN store_m
    ON ins_stock_m.store_id = store_m.store_id
    WHERE ins_stock_m.ins_stock_cmp_date IS NULL;
    
    
--2.2

    CREATE SEQUENCE order_no_seq
    START WITH 5
    INCREMENT BY 1;