how to save result of sqlite query in a table code example

Example 1: how to save result of sqlite query in a table

INSERT INTO `new_tbl` SELECT * FROM table_1 LEFT JOIN table_2 ON table_1.Temp = table_2.Temp;

Example 2: how to save result of sqlite query in a table

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