Using the SUM function, make a report that shows the total sales numbers in each quarter.
mysql> mysql> mysql> CREATE TABLE duck_sales( -> design_num MEDIUMINT NOT NULL AUTO_INCREMENT, -> design_name CHAR(20), -> winter_sales INT, -> spring_sales INT, -> summer_sales INT, -> fall_sales INT, -> design_category CHAR(13), -> primary key(design_num) -> ); Query OK, 0 rows affected (0.00 sec) mysql> mysql> insert into duck_sales(design_name, winter_sales, spring_sales, summer_sales, fall_sales, design_category)values -> ("Duck",1067,200,150,267,"Holiday"), -> ("Mac",970,770,531,486,"Profession"), -> ("Duckula",53,13,21,856,"Literary"), -> ("iPhone",782,357, 168, 250,"Profession"), -> ("HTML",589,795, 367, 284,"Holiday"), -> ("SQL",953,582, 336, 489,"Literary"), -> ("Sherlock_Duck",752,657, 259, 478,"Literary"), -> ("XML",67,23, 83 ,543,"Holiday"), -> ("Database",673,48,625,52,"Profession"); Query OK, 9 rows affected (0.00 sec) Records: 9 Duplicates: 0 Warnings: 0 mysql> mysql> mysql> SELECT SUM(winter_sales) AS "winter total", -> SUM(spring_sales) AS "spring total", -> SUM(summer_sales) AS "summer total", -> SUM(fall_sales) AS "fall total" -> FROM duck_sales; +--------------+--------------+--------------+------------+ | winter total | spring total | summer total | fall total | +--------------+--------------+--------------+------------+ | 5906 | 3445 | 2540 | 3705 | +--------------+--------------+--------------+------------+ 1 row in set (0.00 sec) mysql> mysql> drop table duck_sales; Query OK, 0 rows affected (0.00 sec)