insert into
    CONVENI_SALE_2018(
    SURVEY_YEAR
    ,PF_CODE
    ,TOTAL_VALUE
    )
    select
        SURVEY_YEAR
        ,PF_CODE
        ,TOTAL_VALUE
    from
        CONVENIENCE
    where
        SURVEY_YEAR = 2018
    and
        KIND_CODE = '100'
    and
        TOTAL_VALUE IS not NULL
;