1
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 (the one that has Brazil only once, which is correct) and another with the Moto X2 with Android 6.0 (with data from Brazil divided) in the same application that is in the Play Store in 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
