select ggr.goods_group_name as g_name, count(reg.vagon_num) as count,
    sum(CASE
         WHEN (reg.date_order > '31.12.2018')
         THEN DECODE(reg.distance_id, 1,reg.mass_round)*151
         ELSE DECODE(reg.distance_id, 1, reg.goods_mass)*151
     END) as volt1,
     sum(CASE
          WHEN (reg.date_order > '31.12.2018')
          THEN DECODE(reg.distance_id, 2, reg.mass_round)*19
          ELSE DECODE(reg.distance_id, 2, reg.goods_mass)*19
     END) as volt2,
     sum(CASE
          WHEN (reg.date_order > '31.12.2018')
          THEN DECODE(reg.distance_id, 3, reg.mass_round)*132
          ELSE DECODE(reg.distance_id, 3, reg.goods_mass)*132
     END) as volt3
from dtj_group_name_new2 ggr
left join dtj_goods g on g.goods_group_id = ggr.goods_group_id
left join dtj_reestr reg on g.goods_code = reg.goods_code_id
group by ggr.range_id, ggr.goods_group_name
order by ggr.range_id;

sum(CASE
                   WHEN (reg.date_order > to_date('31.12.2018','DD.MM.YYYY'))
                   THEN DECODE(reg.distance_id, 1, reg.mass_round)*151
                   ELSE DECODE(reg.distance_id, 1, reg.goods_mass)*151
                   END) as volt1,