Mavlonov Xamdam

---

Guruh 650-21 
 
 
Mavlonov Xamdam 
 
 
2-dedline 

1. Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha AND, OR, 
NOT operatorlaridan foydalanib so’rovlar yaratishi va natijasi bilan 
ko’rsatib o’tishi kerak. mysql> select*from xaridorlar;
+----------+--------------+----------+-------------+---------+-----------+
| ism | familaya | ota_ismi | manzil | shahar | telefoni |
+----------+--------------+----------+-------------+---------+-----------+
| Aziza | Ahmedova | Akmaljon | Fergana | Qoqon | 901429851 |
| Arslon | Asliddinov | Akbarjon | Fergana | Qoqon | 911423151 |
| Behzod | Bakirov | Behruz | Qashqadaryo | Kitob | 931449872 |
+----------+--------------+----------+-------------+---------+-----------+
5 rows in set (0.00 sec)
mysql>
select*from xaridorlar where
familaya='Bakirov' 
 
and shahar='Kitob';
+--------+----------+----------+-------------+--------+-----------+
| ism | familaya | ota_ismi | manzil | shahar | telefoni |
+--------+----------+----------+-------------+--------+-----------+
| Behzod | Bakirov | Behruz | Qashqadaryo | Kitob | 991827319 |
+--------+----------+----------+-------------+--------+-----------+
1 row in set (0.00 sec)

mysql>
select*from xaridorlar where
familaya='Bakirov' 
 
or shahar='Kitob';
+----------+----------+----------+-------------+--------+-----------+ |