Calculation : Select « Select Clause « SQL / MySQL

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

Calculation

       
mysql>
mysql> CREATE TABLE IF NOT EXISTS wines
    -> (
    ->   id             INT     AUTO_INCREMENT  PRIMARY KEY,
    ->   type           CHAR(10)        NOT NULL,
    ->   price          DECIMAL(6,2)    NOT NULL,
    ->   quantity       INT             DEFAULT 0
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> INSERT INTO wines (type, price, quantity)   VALUES ("Red", 10.00, 12);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO wines (type, price, quantity)   VALUES ("White", 9.00, 12);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO wines (type, price, quantity)   VALUES ("Rose", 8.00, 6);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> SELECT   type,
    ->  price AS bottle,
    ->  quantity AS qty,
    ->  price * quantity AS subtotal,
    ->  (price * quantity) * (6 / 100) AS tax,
    ->  (price * quantity) +
    ->    (price * quantity) * (6 / 100) AS total
    -> FROM wines ;
+-------+--------+------+----------+----------+------------+
| type  | bottle | qty  | subtotal | tax      | total      |
+-------+--------+------+----------+----------+------------+
| Red   |  10.00 |   12 |   120.00 | 7.200000 | 127.200000 |
| White |   9.00 |   12 |   108.00 | 6.480000 | 114.480000 |
| Rose  |   8.00 |    6 |    48.00 | 2.880000 |  50.880000 |
+-------+--------+------+----------+----------+------------+
3 rows in set (0.00 sec)

mysql>
mysql> # delete this sample table
mysql> DROP TABLE wines;
Query OK, 0 rows affected (0.00 sec)

   
    
    
    
    
    
    
  

Related examples in the same category