--+-----------+ | ism | familaya | ota_ismi | manzil | shahar | telefoni | +------- ---+--------------+----------+-------------+---------+-----------+ | Aziz | Ahmedov | Akmaljon | Fergana | Quvasoy | 901429851 | | Arslon | Asliddinov | Akbarjon | Fergana | Qoqon | 911423151 | | Bekmurod | Bakirov | Bahodir | Qashqadaryo | Qarshi | 931449872 | | Bahrom | Bakirov | Behzod | Qashqadaryo | Kitob | 991827319 | | Elyor | Ergashaliyev | Bobur | Namangan | Chust | 945901298 | +---------- +--------------+----------+----------- --+---------+-----------+ > select ismi,familyasi,tugilgan_sanasi from sotuvchilar -> union -> select ism,familaya,manzil from xaridorlar; +---------------+--------------+----------- ------+ | ismi | familyasi | tugilgan_sanasi | +---------------+--------------+------- ----------+ | 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 | +---------------+---------- ----+-----------------+
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. select * from products; +----+-------------------+---------+--------------+---------------+ | ID | Maxsulotnomi | Brendi | Maxsulotsoni | Maxsulotnarxi | +----+-------------------+---------+--------------+---------------+ | 1 | IPhone 13 pro MAX | Apple |
