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
;