Can you create an SQL/SQLlite query to SEARCH for a range and TRANSFER data from one table to another?

edit

Yes, here is an example query:

INSERT INTO target_table (column1, column2, column3)
SELECT source_table.column1, source_table.column2, source_table.column3
FROM source_table
WHERE source_table.column3 BETWEEN 100 AND 200; 

This query transfers data from "sourcetable" to "targettable" only where the value in "column3" falls within the range of 100 to 200. Change the column names and table names as per your requirements.