Mavlonov Xamdam

+------+-------------------+--------+----------+----------+
2 rows in set (0.00 sec)

mysql> select*from xaridorlar order by telefoni;
+----------+--------------+----------+-------------+---------+-----------+
| 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 |
| Bahrom | Bakirov | Behzod | Qashqadaryo | Kitob | 991827319 |
+----------+--------------+----------+-------------+---------+-----------+ 5 
rows in set (0.00 sec)

mysql> select*from xaridorlar order by telefoni desc;
+----------+--------------+----------+-------------+---------+-----------+
| ism | familaya | ota_ismi | manzil | shahar | telefoni |
+----------+--------------+----------+-------------+---------+-----------+
| Bahrom | Bakirov | Behzod | Qashqadaryo | Kitob | 991827319 |
| Elyor | Ergashaliyev | Bobur | Namangan | Chust | 945901298 |
| Bekmurod | Bakirov | Bahodir | Qashqadaryo | Qarshi | 931449872 |
| Arslon | Asliddinov | Akbarjon | Fergana | Qoqon | 911423151 |
| Aziz | Ahmedov | Akmaljon | Fergana | Quvasoy | 901429851 |
+----------+--------------+----------+-------------+---------+-----------+ 5 
rows in set (0.00 sec)

mysql> select count(*),ism,familaya from xaridorlar