codice:
select iif(tipo=1,"pari","dispari") as tipo_treno, count(tipo) as quanti
from (select iif(treno mod 2 = 0,1,2) as tipo
from tabella) as t
group by tipo