SQL

test.sql

mysql> use trade;
Database changed
mysql> select * from mall;
+------+-------------+-------+---------+------------+
| code | mname       | owner | city    | no_of_mall |
+------+-------------+-------+---------+------------+
|  111 | FUN         | XYZ   | DELHI   |          3 |
|  222 | PVR         | ABC   | LUCKNOW |          8 |
|  333 | WAVE        | XYZ   | KANPUR  |          3 |
|  444 | CITY CENTER | XYZ   | DELHI   |          4 |
|  555 | GLOBE       | ABC   | LUCKNOW |          6 |
+------+-------------+-------+---------+------------+
5 rows in set (0.05 sec)

mysql> select city from mall where owner like "ABC";
+---------+
| city    |
+---------+
| LUCKNOW |
| LUCKNOW |
+---------+
2 rows in set (0.00 sec)

mysql> select mname from mall  where mname like "w%";
+-------+
| mname |
+-------+
| WAVE  |
+-------+
1 row in set (0.00 sec)

mysql> select code, mname from mall where no_of_mall > 2 and no_of_mall < 6;
+------+-------------+
| code | mname       |
+------+-------------+
|  111 | FUN         |
|  333 | WAVE        |
|  444 | CITY CENTER |
+------+-------------+
3 rows in set (0.02 sec)

mysql> select city, sum(no_of_mall) from mall group by city;
+---------+-----------------+
| city    | sum(no_of_mall) |
+---------+-----------------+
| DELHI   |               7 |
| KANPUR  |               3 |
| LUCKNOW |              14 |
+---------+-----------------+
3 rows in set (0.02 sec)

mysql> select distinct(owner) from mall;
+-------+
| owner |
+-------+
| XYZ   |
| ABC   |
+-------+
2 rows in set (0.00 sec)