MariaDB [dblaweb]> SELECT * FROM paises_invitados where Id_Pais = 1 ORDER BY Usuarios desc LIMIT 5;
+---------+----------------+-------------+------------+
| Id_pais | Pais | Estados | Usuarios |
+---------+----------------+-------------+------------+
| 1 | Estados Unidos | Dallas | 2147483647 |
| 1 | Estados Unidos | Houston | 2147483647 |
| 1 | Estados Unidos | Miami | 1545222767 |
| 1 | Estados Unidos | Los Angeles | 545222989 |
| 1 | Estados Unidos | Kansas | 432423151 |
+---------+----------------+-------------+------------+
5 rows in set (0.00 sec)
MariaDB [dblaweb]>
MariaDB [dblaweb]> SELECT * FROM paises_invitados where Id_Pais = 2 ORDER BY Usuarios desc LIMIT 5;
+---------+--------+-------------+------------+
| Id_pais | Pais | Estados | Usuarios |
+---------+--------+-------------+------------+
| 2 | Mexico | Monterrey | 2147483647 |
| 2 | Mexico | Durango | 2147483647 |
| 2 | Mexico | Puebla | 2147483647 |
| 2 | Mexico | Tijuana | 543534534 |
| 2 | Mexico | Guadalajara | 524234234 |
+---------+--------+-------------+------------+
5 rows in set (0.00 sec)
MariaDB [dblaweb]>
MariaDB [dblaweb]> SELECT * FROM paises_invitados where Id_Pais = 3 ORDER BY Usuarios desc LIMIT 5;
+---------+--------+---------------+-----------+
| Id_pais | Pais | Estados | Usuarios |
+---------+--------+---------------+-----------+
| 3 | Espa±a | Barcelona | 534576877 |
| 3 | Espa±a | Granada | 345345354 |
| 3 | Espa±a | Alicante | 243465452 |
| 3 | Espa±a | San Sebastian | 45334524 |
| 3 | Espa±a | Valencia | 42445532 |
+---------+--------+---------------+-----------+
5 rows in set (0.00 sec)
MariaDB [dblaweb]>