| 2 | Zoirov Qobiljon | sotuvchi | | 3 | Esanmurodova Serion | amaliyotchi | +------+----------------------+-------------+ select * from mijozlar -> where ismi like '%xon%'; +------+-----------+------------+------------------+---------------+------------------------- ---------------------+----------------+-----------------------------------+ | M_ID | Ismi | Familiyasi | Ochestvasi | Mulk_turi | Mijoz_manzili | Telefon_raqami | Aloqadagi_shaxs | +------+-----------+------------+------------------+---------------+------------------------- ---------------------+----------------+-----------------------------------+ | 1 | Nozimaxon | Mo`minova | Baxtiyorjon qizi | ko`chmas mulk | Farg`ona viloyati Farg`ona tumani Mindon MFY | +998911300994 | Valijon Alijonov Akmaljon o`g`li | +------+-----------+------------+------------------+---------------+------------------------- ---------------------+----------------+-----------------------------------+ 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. select * from mijozlar -> ORDER BY M_ID; +------+-----------+------------+------------------+---------------+------------------------- -----------------------+----------------+-----------------------------------+ | M_ID | Ismi | Familiyasi | Ochestvasi | Mulk_turi | Mijoz_manzili | Telefon_raqami | Aloqadagi_shaxs | +------+-----------+------------+------------------+---------------+------------------------- -----------------------+----------------+-----------------------------------+ | 1 | Nozimaxon | Mo`minova | Baxtiyorjon qizi | ko`chmas mulk | Farg`ona
