karan_singh
New Contributor II

Hi, 

Specify insert columns as below

 
%sql
INSERT INTO demo_test (product_type, sales)
SELECT product_type, sales FROM demo