Código PHP:
(SELECT country, COUNT(provider_id)AS total
FROM provider GROUP by country ORDER BY total DESC Limit 5)
UNION
(SELECT 'otros' AS country, COUNT(provider_id) AS total FROM provider WHERE NOT EXISTS (SELECT country, COUNT(provider_id)AS total
FROM provider GROUP by country ORDER BY total DESC Limit 5))
Que me saca lo siguiente:

Como se vé no alcanza a hacer la Suma de la forma que necesito que sería:

Agradezco toda la ayuda.
