Use the basic mathematical operators : Operator « Select Clause « SQL / MySQL

1. SQL / MySQL
2. Select Clause
3. Operator

Use the basic mathematical operators

      
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)

   
    
    
    
    
    
  

Related examples in the same category