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 REPLACE(design_name, "_", " ") AS Outfit,
-> winter_sales+spring_sales+summer_sales+fall_sales AS "Yearly Sales",
-> design_category AS Category
-> FROM duck_sales;
+---------------+--------------+------------+
| Outfit | Yearly Sales | Category |
+---------------+--------------+------------+
| Duck | 1684 | Holiday |
| Mac | 2757 | Profession |
| Duckula | 943 | Literary |
| iPhone | 1557 | Profession |
| HTML | 2035 | Holiday |
| SQL | 2360 | Literary |
| Sherlock Duck | 2146 | Literary |
| XML | 716 | Holiday |
| Database | 1398 | Profession |
+---------------+--------------+------------+
9 rows in set (0.00 sec)
mysql>
mysql> drop table duck_sales;
Query OK, 0 rows affected (0.00 sec)