CODE EXAMPLE FOR SQL

how to save result of sqlite query in a table

CREATE TABLE `new_tbl` (`date` datetime , `temp1` int , `count` int , `temp2` int );