select
  nm_cli,
  sum(vl_trn) as tot_trn
from
  tb_cli left join tb_trn on (tb_cli.id_cli = tb_trn.id_cli)
group by nm_cli;