What is the correct syntax to insert a query result into another table and sort the result by a specific column in descending order?

Question

Answer

INSERT INTO new_table (column1, column2)  
 SELECT column1, column2  
 FROM original_table;

Answer

INSERT INTO new_table  
 SELECT *  
 FROM original_table  
 ORDER BY column3 DESC;

Answer

INSERT INTO new_table 
 SET = SELECT *  
 FROM original_table  
 ORDER BY column3 DESC

Answer

INSERT INTO new_table (column1, column2, column3)  
 SELECT column1, column2, column3  
 FROM original_table  
 ORDER BY column3 DESC;

Crowdly