The attached screens are the result of the same query on a tablet with Android 4.1.2 and a Galaxy S3 with Android 4.3 (which has Brazil only once, which is correct) and another with Moto X2 with Android 6.0 (with the data from Brazil divided) in the same app that is in the Play Store at the link below.
Running SQL in a Firebird database is also correct.
The SQL used is the following:
select ‘’ as est_estado,
(case when d.tor_intern = ‘S’ then est_pais else
b.clu_estado end) as est_pais,
count(*) as pon_titulo
from PONTOS a, CLUBES b, ESTADOS c, TORNEIOS d
where a.tor_codigo = ‘CONMEB’ AND
a.clu_ordem = b.clu_ordem and
b.clu_estado = c.clu_estado and
a.tor_codigo = d.tor_codigo AND
pon_classi = 1
group by est_estado, est_pais
order by pon_titulo desc, est_pais
To download the app