i want insert more than two line qry insert in single column with more single quotes
What I have tried:
Insert into TEMP_TABLE(userid,chartid,id,qry,y1,y2)Values('1','chart0','chart0',' select ef_week as text,Sum(actualproduction) as actualproduction , avg (Productionefficiency) as productionefficiency from EFFICIENCY where actualproduction !=0 and date(ReportDate) between '2016-01-01' and '2016-08-29' group by ef_week order by ef_week ','actualproduction','Productionefficiency')