insert into CONVENI_SALE_2018 (SURVEY_YEAR, PF_CODE, TOTAL_VALUE)
values(

(select SURVEY_YEAR
from CONVENIENCE
where
  SURVEY_YEAR = 2018
  and KIND_CODE = 100
  and TOTAL_VALUE is not null
  ),
(select PF_CODE
from CONVENIENCE
where
  SURVEY_YEAR = 2018
  and KIND_CODE = 100
  and TOTAL_VALUE is not null
  ),
(select TOTAL_VALUE
from CONVENIENCE
where
  SURVEY_YEAR = 2018
  and KIND_CODE = 100
  and TOTAL_VALUE is not null
  )
  
)