-> min(narxi) as arzon, -> avg(narxi) as orta from mahsulot; +------+--------------------------+--------+-------+-------------+ | soni | sum(mahsulot_soni*narxi) | qimmat | arzon | orta | +------+--------------------------+--------+-------+-------------+ | 5 | 9016000 | 850100 | 1000 | 212620.0000 | +--- ---+--------------------------+--------+-------+-------------+ 1 row in set (0.00 sec) 7 . Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha STANDART FUNKSIYALARDAN foydalanib so’rovlar yaratishi va natijasi bilan ko’rsatib o’tishi kerak mysql> select*from sotuvchilar; +-------------+---------------+----------------+----------------------+----------------+ | familyasi | ismi | otasining_ismi | kelib_tushgan_sanasi | tugilgan_sanasi | +-------------+---------------+----------------+----------------------+----------------+ | Karimov | Muhammaddiyor | Akmaljon | 2021-04-21 | 2004 | | Ahmedov | Oybek | Akram | 2020-08-19 | 2003 | | Ahmedov | Akmal | Akbar | 2020-03-20 | 2003 | | Asliddinov | Kamol | Davlatjon | 2021-09-18 | 2000 | | Abdukarimov | Asliddin | Akbarali | 2022-04-30 | 2004 |
+-------------+---------------+----------------+----------------------+----------------+ 5 rows in set (0.00 sec) mysql> select MONTHNAME(kelib_tushgan_sanasi) from sotuvchilar;
