How can you insert the result of a SELECT query with a GROUP BY clause and an ORDER BY the sum in descending order into a new table in PostgreSQL?

Question

Answer

INSERT INTO new_table  
 SELECT column1, column2, SUM(column3)  
 FROM original_table  
 GROUP BY column1, column2  
 ORDER BY column3 ASC;

Answer

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

Answer

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

Answer

INSERT INTO new_table  
 SELECT column1, column2, AVG(column3)  
 FROM original_table  
 GROUP BY column1, column2  
 ORDER BY column3 ASC;

Answer

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

Crowdly

How can you insert the result of a SELECT query with a GROUP BY clause and an O...

Want instant access to all verified answers on softserve.academy?