INSERT INTO CONVENI_SALE_2018
select
  SURVEY_YEAR
  , PF_CODE
  , TOTAL_VALUE

from CONVENIENCE
where SURVEY_YEAR = 2018
  and KIND_CODE = '100'
  and TOTAL_VALUE IS NOT NULL

;