Number of record holders per country

+----------------------------------+---------------+---------+
| countryId                        | recordHolders | records |
+----------------------------------+---------------+---------+
| Democratic Republic of the Congo |             1 |       1 |
| Monaco                           |             1 |       2 |
| Trinidad and Tobago              |             1 |       2 |
| Senegal                          |             1 |       2 |
| Uganda                           |             1 |       2 |
| Malawi                           |             1 |       2 |
| Angola                           |             1 |       2 |
| Samoa                            |             1 |       2 |
| Somalia                          |             1 |       4 |
| Namibia                          |             1 |       4 |
| Zambia                           |             1 |       4 |
| Grenada                          |             1 |       4 |
| Bhutan                           |             1 |       6 |
| Guyana                           |             1 |       6 |
| Tanzania                         |             1 |       6 |
| Bahamas                          |             1 |       8 |
| Suriname                         |             1 |      11 |
| Togo                             |             1 |      11 |
| Liechtenstein                    |             1 |      21 |
| Brunei                           |             1 |      22 |
| Haiti                            |             1 |      25 |
| Saint Kitts and Nevis            |             1 |      26 |
| Jamaica                          |             2 |       6 |
| Turkmenistan                     |             2 |       9 |
| Cote d_Ivoire                    |             2 |      10 |
| Ghana                            |             2 |      15 |
| Zimbabwe                         |             2 |      18 |
| Nicaragua                        |             2 |      27 |
| Tajikistan                       |             2 |      28 |
| Kenya                            |             3 |       6 |
| Sudan                            |             3 |       8 |
| Papua New Guinea                 |             3 |      11 |
| United Arab Emirates             |             3 |      12 |
| Albania                          |             3 |      14 |
| Iraq                             |             3 |      14 |
| Oman                             |             3 |      14 |
| Syria                            |             3 |      15 |
| Andorra                          |             3 |      15 |
| Mauritius                        |             3 |      20 |
| Kosovo                           |             3 |      22 |
| Morocco                          |             3 |      24 |
| Greece                           |             4 |       7 |
| Cuba                             |             4 |      12 |
| Afghanistan                      |             4 |      15 |
| Saudi Arabia                     |             4 |      15 |
| Macau                            |             4 |      28 |
| North Macedonia                  |             4 |      28 |
| Pakistan                         |             4 |      32 |
| Tunisia                          |             4 |      33 |
| Malta                            |             5 |      12 |
| Libya                            |             5 |      14 |
| Cambodia                         |             5 |      14 |
| Sri Lanka                        |             5 |      16 |
| Georgia                          |             5 |      21 |
| Bahrain                          |             5 |      22 |
| Kuwait                           |             5 |      22 |
| Lebanon                          |             5 |      22 |
| Cyprus                           |             5 |      24 |
| Algeria                          |             5 |      26 |
| Moldova                          |             5 |      27 |
| Nigeria                          |             5 |      27 |
| Luxembourg                       |             5 |      35 |
| Portugal                         |             5 |      36 |
| Kyrgyzstan                       |             6 |      22 |
| Montenegro                       |             6 |      23 |
| Croatia                          |             6 |      26 |
| Iceland                          |             6 |      31 |
| Madagascar                       |             7 |      10 |
| Palestine                        |             7 |      19 |
| Azerbaijan                       |             7 |      26 |
| Armenia                          |             7 |      32 |
| Lithuania                        |             7 |      37 |
| Denmark                          |             7 |      40 |
| Bosnia and Herzegovina           |             8 |      29 |
| Slovenia                         |             8 |      37 |
| Panama                           |             9 |      30 |
| Mongolia                         |             9 |      30 |
| Slovakia                         |             9 |      34 |
| Bulgaria                         |             9 |      36 |
| Singapore                        |             9 |      39 |
| Jordan                           |            10 |      27 |
| Bangladesh                       |            10 |      31 |
| Ireland                          |            10 |      36 |
| Austria                          |            10 |      38 |
| Egypt                            |            11 |      24 |
| Venezuela                        |            11 |      31 |
| Turkey                           |            11 |      32 |
| Uzbekistan                       |            11 |      32 |
| Uruguay                          |            11 |      33 |
| Israel                           |            11 |      35 |
| Czech Republic                   |            11 |      37 |
| Estonia                          |            11 |      37 |
| South Africa                     |            11 |      37 |
| Dominican Republic               |            12 |      30 |
| Honduras                         |            12 |      30 |
| Thailand                         |            12 |      37 |
| Norway                           |            12 |      38 |
| Argentina                        |            12 |      39 |
| New Zealand                      |            12 |      40 |
| Finland                          |            12 |      40 |
| Paraguay                         |            13 |      30 |
| Switzerland                      |            13 |      36 |
| Romania                          |            13 |      38 |
| Latvia                           |            13 |      39 |
| Costa Rica                       |            14 |      31 |
| El Salvador                      |            14 |      32 |
| Serbia                           |            14 |      33 |
| Netherlands                      |            14 |      38 |
| Sweden                           |            14 |      41 |
| Nepal                            |            15 |      32 |
| Bolivia                          |            15 |      33 |
| Guatemala                        |            15 |      33 |
| Hong Kong                        |            15 |      37 |
| Indonesia                        |            15 |      38 |
| Belarus                          |            15 |      38 |
| Peru                             |            15 |      38 |
| Italy                            |            15 |      40 |
| Chile                            |            16 |      35 |
| Colombia                         |            16 |      37 |
| Kazakhstan                       |            16 |      37 |
| Australia                        |            16 |      40 |
| Malaysia                         |            16 |      41 |
| Canada                           |            16 |      43 |
| Iran                             |            17 |      35 |
| Vietnam                          |            17 |      35 |
| Korea                            |            17 |      39 |
| Belgium                          |            17 |      40 |
| Ecuador                          |            18 |      30 |
| Taiwan                           |            18 |      40 |
| Poland                           |            18 |      41 |
| Ukraine                          |            19 |      38 |
| Mexico                           |            19 |      39 |
| Spain                            |            19 |      39 |
| Hungary                          |            19 |      41 |
| France                           |            19 |      41 |
| Germany                          |            19 |      42 |
| Russia                           |            20 |      41 |
| Japan                            |            21 |      41 |
| China                            |            23 |      40 |
| USA                              |            23 |      41 |
| India                            |            23 |      41 |
| Brazil                           |            24 |      42 |
| Philippines                      |            25 |      40 |
| United Kingdom                   |            25 |      41 |
+----------------------------------+---------------+---------+

mysql> select countryId, count(distinct personId) as recordHolders, count(1) as records from (select * from RanksAverage union all select * from RanksSingle) as Ranks join Persons on Ranks.personId=Persons.id where countryRank=1 and subid=1 group by 1 order by 2 asc, 3 asc;