1. Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha and, or

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 xodimlar WHERE `lavozim`='mexanik'; 
+----------+-----------+--------------+------------------+---------+---------+------------------+ 
| xodim_id | ism | familiya | ishga_kirgan_yil | maosh | lavozim | ish vaqti (soat) | 
+----------+-----------+--------------+------------------+---------+---------+------------------+ 
| 6 | Shukurullo | Abdulhamidov | 2017 | 2000000 | mexanik | 8 | 
| 7 | Nosirjon | Mahamadjonov | 2017 | 2000000 | mexanik | 8 | 
+----------+-----------+--------------+------------------+---------+---------+------------------+ 2 
rows in set (0.00 sec) 
3. Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha Order by,
Group by operatorlaridan foydalanib so’rovlar yaratishi va natijasi bilan 
ko’rsatib o’tishi kerak. 
mysql> SELECT * FROM xodimlar ORDER BY maosh;
+----------+-------------+--------------+------------------+---------+--------------------+------------------+ | 
xodim_id | ism | familiya | ishga_kirgan_yil | maosh | lavozim | ish vaqti (soat) | 
+----------+-------------+--------------+------------------+---------+--------------------+------------------+
| 6 | Shukurullo | Abdulhamidov | 2017 | 2000000 | mexanik | 8 |
| 7 | Nodirbek | Mahamadjonov | 2017 | 2000000 | mexanik | 8 |
| 4 | Behzod | Keldiyev | 2017 | 2200000 | ishchi xodim | 8 |
| 5 | Abdulla | Komilov | 2017 | 2200000 | ishchi xodim | 8 |
| 2 | Otabek | Tursunov | 2017 | 2500000 | sifat nazoratchisi | 8 |
| 3 | Asror | Nosiraliyev | 2017 | 2500000 | sifat nazoratchisi | 8 |
| 8 | Muhammadrizo | Rayimjonov | 2017 | 3000000 | nazoratchi | 8 |
| 1 | Islomjon | Ismoilov | 2017 | 5000000 | direktor | 8 |
+----------+-------------+--------------+------------------+---------+--------------------+------------------+
8 rows in set (0.00 sec)

---

mysql> SELECT COUNT(xodim_id), lavozim FROM xodimlar GROUP BY lavozim; 
+-----------------+--------------------+ 
| COUNT(xodim_id) | lavozim | 
+-----------------+--------------------+ 
| 1 | direktor | 
| 2 | sifat nazoratchisi | 
| 2 | ishchi xodim | 
| 2 | mexanik | 
| 1 | nazoratchi | 
+-----------------+--------------------+ 
5 rows in set (0.00 sec)