select production_name, 
                case consignee_form 
                       when "Ч/Л" then "Частное лицо" 
                else consignee_form||" "||consignee_name end, 
                sum(gross-container)
from main m, consignee con, production pr
where m.doc_id= 1262  and
      m.del is null and
      m.consignee_id=con.consignee_id and
      m.production_id=pr.production_id and
      m.kach_ud_id=lab.kach_ud_id and (lab.kindtara_id= 1  or pr.production_id= 5  or pr.production_id= 6 )
group by production_name, 
            case consignee_form 
                   when "Ч/Л" then "Частное лицо" 
                   else consignee_form||" "||consignee_name end

select production_name, consignee_form||" "||consignee_name, 
                sum(gross-container)
и group by production_name, consignee_form||" "||consignee_name

select production_name, consignee_form||" "||consignee_name, 
                sum(gross-container)
и group by production_name, consignee_form||" "||consignee_name