+----------+--------------+----------+-------------+---------+-----------+ | 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 | | Elyor | Ergashaliyev | Bobur | Namangan | Chust | 945901298 | +----------+--------------+----------+-------------+---------+-----------+ 4 rows in set (0.00 sec) mysql> select*from sotish where dori like '%nol%'; +------+-------------------+--------+----------+----------+ | soni | dori | miqdor | retsept | sotuvchi | +------+-------------------+--------+----------+----------+ | 30 | Bolnol relaks gel | 25-40 | 2 mahal | Diyor | | 21 | Nol gripp | 25-40 | 1 mahal | Elyor | +------+-------------------+--------+----------+----------+ 2 rows in set (0.00 sec) 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. mysql> select*from sotish where dori like '%nol%' order by soni; +------+-------------------+--------+----------+----------+ | soni | dori | miqdor | retsept | sotuvchi | +------+-------------------+--------+----------+----------+
