Mavlonov Xamdam

-> group by shahar;
+----------+----------+--------------+
| count(*) | ism | familaya |
+----------+----------+--------------+
| 1 | Elyor | Ergashaliyev |
| 1 | Bahrom | Bakirov |
| 1 | Bekmurod | Bakirov |
| 1 | Arslon | Asliddinov |
| 1 | Aziz | Ahmedov |

---

+----------+----------+--------------+
5 rows in set (0.00 sec)

mysql> select count(*),ism,shahar from xaridorlar
-> group by familaya;
+----------+----------+---------+
| count(*) | ism | shahar |
+----------+----------+---------+
| 1 | Aziz | Quvasoy |
| 1 | Arslon | Qoqon |
| 2 | Bekmurod | Qarshi |
| 1 | Elyor | Chust |
+----------+----------+---------+
4 rows in set (0.00 sec)
4.Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha HAVING
operatoridan foydalanib so’rovlar yaratishi va natijasi bilan ko’rsatib o’tishi
kerak.

mysql> select count(*),ism from xodim > 
group by familyasi having 'soni'=1;
Empty set, 1 warning (0.00 sec)
5. Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha UNION, 
INTERSECT, MINUS operatorlaridan foydalanib so’rovlar yaratishi va natijasi 
bilan ko’rsatib o’tishi kerak. mysql> select*from xaridorlar;
+----------+--------------+----------+-------------+---------+-----------+
| ism | familaya | ota_ismi | manzil | shahar | telefoni |