SQL & PL/SQL

CREATE TABLE Sales (Month VARCHAR(20) ,SaleAmount INT)


INSERT INTO Sales VALUES ('January', 100)
INSERT INTO Sales VALUES ('February', 200)
INSERT INTO Sales VALUES ('March', 300)

SELECT * FROM SALES
 

Month             SaleAmount
—————-  ———–
January           100
February          200
March             300 

desired output :

top_month     AVG       SUM

March             200        600