Mavlonov Xamdam

',DAYNAME(kelib_tushgan_sanasi)) from sotuvchilar;
+---------------------------------------------------------------------------+
|
CONCAT(MONTHNAME(kelib_tushgan_sanasi),'
',DAYNAME(kelib_tushgan_sanasi)) |
+---------------------------------------------------------------------------+
| April Wednesday |
| August Wednesday |
| March Friday |
| September Saturday |
| April Saturday |
+---------------------------------------------------------------------------+
5 rows in set (0.00 sec)
8.Har bir talaba o’ziga berilgan predmet soha mavzusi 
bo’yicha murakkab so’rovlar yaratishi va natijasi bilan 
ko’rsatib o’tishi kerak
.
mysql> select*from xodim where id= ANY 
-> (select id from jarayon); 
+----+--------------+---------------+----------------+-----------+ 
| id | familyasi | ism | otasining_ismi | telefon | 
+----+--------------+---------------+----------------+-----------+ 
| 1 | Bakirov | Bekmurod | Botirjon | 994672150 | 
| 2 | Ergashaliyev | Elyor | Toxirjon | 932709421 | 
| 3 | Bakirov |Bahrom| Dilshodjon | 911447793 | 
4 rows in set (0.00 sec) 

---

mysql> select*from xodim where id= ANY 
-> (select id mijoz); 
+----+--------------+---------------+----------------+-----------+ 
| id | familyasi | ism | otasining_ismi | telefon | 
+----+--------------+---------------+----------------+-----------+ 
| 1 | Bakirov| Bekmurod | Botirjon | 994672150 | 
| 2 | Ergashaliyev | Elyor | Toxirjon | 932709421 | 
| 3 | Bakirov |Bahrom| Dilshodjon | 911447793 | 
+----+--------------+---------------+----------------+-----------+ 
4 rows in set (0.00 sec) 

mysql> select*from xodim where id = ANY 
-> (select id from mijoz); 
+----+--------------+---------------+----------------+-----------+ 
| id | familyasi | ism | otasining_ismi | telefon | 
+----+--------------+---------------+----------------+-----------+ 
| 1 | Bakiorv | Bekmurod | Botirjon | 994672150 | 
| 2 | Ergashaliyev | Elyor | Toxirjon | 932709421 | 
| 3 | Bakirov |Bahrom| Dilshodjon | 911447793 | 
|
+----+--------------+---------------+----------------+-----------+ 
4 rows in set (0.00 sec) 

mysql> select*from xodim where id != ALL 
-> (select id from jarayon); 
Empty set (0.00 sec) 

mysql> select*from xodim where id != ALL 
-> (select id from mijoz); Empty set 
(0.00 sec)