| Muhammaddiyor | Karimov | 2004 | | Oybek | Ahmedov | 2003 | | Akmal | Ahmedov | 2003 | | Kamol | Asliddinov | 2000 | | Asliddin | Abdukarimov | 2004 | | Aziz | Ahmedov | Fergana | | Arslon | Asliddinov | Fergana | | Bekmurod | Bakirov | Qashqadaryo | | Bahrom | Bakirov | Qashqadaryo | | Elyor | Ergashaliyev | Namangan | +---------------+--------------+-----------------+ 10 rows in set (0.00 sec) mysql> select ism from xaridorlar where ism not in -> (select ism from xaridorlar); Empty set (0.00 sec) 6!Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha AVG, SUM, MIN, MAX,COUNT operatoridan foydalanib so’rovlar yaratishi va natijasi bilan ko’rsatib o’tishi kerak . mysql> select*from mahsulot; +----+---------------+------------+---------------+--------+ | id | mahsulot_nomi | brend_nomi | mahsulot_soni | narxi | +----+---------------+------------+---------------+--------+
| 1 | Iphone X | Apple | 3 | 76000 | | 2 | Iphone 8 | Apple | 2 | 51000 | | 3 | Galaxy S9 | Samsung | 2 | 85000 | | 4 | Honor | Huawei | 10 | 850100 | | 5 | Redmi 10 | Redmi | 15 | 1000 | +----+---------------+------------+---------------+--------+ 5 rows in set (0.00 sec) mysql> select count(*) as soni > , sum(mahsulot_soni*narxi), -> max(narxi) as qimmat,