Mavlonov Xamdam

ism | familaya | ota_ismi | manzil | shahar | telefoni |
+----------+----------+----------+-------------+--------+-----------+
| Behzod | Bakirov | Behruz | Qashqadaryo | Kitob | 991827319 |
+----------+----------+----------+-------------+--------+-----------+
2 rows in set (0.00 sec)

mysql> select*from xaridorlar where not (familaya='Bakirov' or 
shahar='Kitob'); +--------+--------------+----------+----------+---------+----------
-+ | ism | familaya | ota_ismi | manzil | shahar | telefoni | +--------+---
-----------+----------+----------+---------+-----------+
| Aziza | Ahmedova | Akmaljon | Fergana | Quvasoy | 901429851 |

---

| Arslon | Asliddinov | Akbarjon | Fergana | Qoqon | 911423151 |
+--------+--------------+----------+----------+---------+-----------+ 3 
rows in set (0.00 sec)
2.Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha WHERE, 
IN, BETWEEN, LIKE operatorlaridan foydalanib so’rovlar yaratishi va 
natijasi bilan ko’rsatib o’tishi kerak. mysql> select*from sotish where soni 
in(30,21); +------+-------------------+--------+----------+----------+
| soni | dori | miqdor | retsept | sotuvchi |
+------+-------------------+--------+----------+----------+
| 30 | Bolnol relaks gel | 25-40 | 2 mahal | Diyor |
| 21 | Nol gripp | 25-40 | 1 mahal | Elyor |
+------+-------------------+--------+----------+----------+
2 rows in set (0.00 sec)
mysql> select*from xaridorlar where telefoni between
-> '901429851' and '945901298';