create table sales(
    -> SalesID int not null,
    -> OrderDescription varchar(100) not null,
    -> Quantity int not null,
    -> Price int not null,
    -> ItemDescription varchar(100),
    -> primary key(SalesID));
Query OK, 0 rows affected (0.24 sec)

MariaDB [sales]> describe sales;
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| SalesID          | int(11)      | NO   | PRI | NULL    |       |
| OrderDescription | varchar(100) | NO   |     | NULL    |       |
| Quantity         | int(11)      | NO   |     | NULL    |       |
| Price            | int(11)      | NO   |     | NULL    |       |
| ItemDescription  | varchar(100) | YES  |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+
5 rows in set (0.04 sec)

MariaDB [sales]> insert into sales values(100,"Frock",20,1200,"New with tag"),(200,"Trouser",15,1850,"");
Query OK, 2 rows affected (0.14 sec)
Records: 2  Duplicates: 0  Warnings: 0

MariaDB [sales]> insert into sales values(300,"T-Shirts",30,1300,"New with tag"),(400,"Shirts",25,2000,"");
Query OK, 2 rows affected (0.14 sec)
Records: 2  Duplicates: 0  Warnings: 0

MariaDB [sales]> select * from sales;
+---------+------------------+----------+-------+-----------------+
| SalesID | OrderDescription | Quantity | Price | ItemDescription |
+---------+------------------+----------+-------+-----------------+
|     100 | Frock            |       20 |  1200 | New with tag    |
|     200 | Trouser          |       15 |  1850 |                 |
|     300 | T-Shirts         |       30 |  1300 | New with tag    |
|     400 | Shirts           |       25 |  2000 |                 |
+---------+------------------+----------+-------+-----------------+
4 rows in set (0.00 sec)

MariaDB [sales]> select SalesID,OrderDescription from sales;
+---------+------------------+
| SalesID | OrderDescription |
+---------+------------------+
|     100 | Frock            |
|     200 | Trouser          |
|     300 | T-Shirts         |
|     400 | Shirts           |
+---------+------------------+
4 rows in set (0.00 sec)

MariaDB [sales]> select * from sales where salesid=200
    -> ;
+---------+------------------+----------+-------+-----------------+
| SalesID | OrderDescription | Quantity | Price | ItemDescription |
+---------+------------------+----------+-------+-----------------+
|     200 | Trouser          |       15 |  1850 |                 |
+---------+------------------+----------+-------+-----------------+
1 row in set (0.07 sec)

MariaDB [sales]> select orderdescription from sales where salesid=200;
+------------------+
| orderdescription |
+------------------+
| Trouser          |
+------------------+
1 row in set (0.00 sec)

MariaDB [sales]> SELECT price*1.1 FROM sales;
+-----------+
| price*1.1 |
+-----------+
|    1320.0 |
|    2035.0 |
|    1430.0 |
|    2200.0 |
+-----------+
4 rows in set (0.00 sec)

MariaDB [sales]> SELECT price*1.1 as NewPrice FROM sales;
+----------+
| NewPrice |
+----------+
|   1320.0 |
|   2035.0 |
|   1430.0 |
|   2200.0 |
+----------+
4 rows in set (0.00 sec)

MariaDB [sales]> select salesid from sales where price < 1500;
+---------+
| salesid |
+---------+
|     100 |
|     300 |
+---------+
2 rows in set (0.00 sec)

MariaDB [sales]> select orderdescription from sales where price > 1500 and price < 2000;
+------------------+
| orderdescription |
+------------------+
| Trouser          |
+------------------+
1 row in set (0.00 sec)

MariaDB [sales]> select * from sales where
    -> orderdescription not like 'Frock'
    -> and orderdescription not like 'Trouser'
    -> and orderdescription not like 'T-Shirts'
    -> and orderdescription not like 'Shirts';
Empty set (0.00 sec)

MariaDB [sales]> select orderdescription from sales where price > 1500 or quantity < 15;
+------------------+
| orderdescription |
+------------------+
| Trouser          |
| Shirts           |
+------------------+
2 rows in set (0.00 sec)

MariaDB [sales]> select orderdescription from sales where price > 1500 or quantity > 20;
+------------------+
| orderdescription |
+------------------+
| Trouser          |
| T-Shirts         |
| Shirts           |
+------------------+
3 rows in set (0.00 sec)

MariaDB [sales]> select orderdescription from sales where price != 1500;
+------------------+
| orderdescription |
+------------------+
| Frock            |
| Trouser          |
| T-Shirts         |
| Shirts           |
+------------------+
4 rows in set (0.00 sec)

MariaDB [sales]> select * from sales order by price DESC;
+---------+------------------+----------+-------+-----------------+
| SalesID | OrderDescription | Quantity | Price | ItemDescription |
+---------+------------------+----------+-------+-----------------+
|     400 | Shirts           |       25 |  2000 |                 |
|     200 | Trouser          |       15 |  1850 |                 |
|     300 | T-Shirts         |       30 |  1300 | New with tag    |
|     100 | Frock            |       20 |  1200 | New with tag    |
+---------+------------------+----------+-------+-----------------+
4 rows in set (0.00 sec)