Need output as summarized form of total

Dear Members,

I have a table “Processor types” with column name processor.

Query

SELECT processor, SUM(processor) AS Total from processor-types where (processor like ‘%i210%’)
and ddate like ‘20161009’ group by processor

output

Processor Total
i210at 4
i210-at 6
i210 2016 8
intel+ethernet+connection+i210 1
wgi210it+s+ljxt 4
wgi210is_sljxx 3
i210-t1 4
ethernet i210-t1 5
intelâ® ethernet controller i210-at 5
wgi210is 2

But I need output in the summarized form of the total and generic name in processor column as i210.

Eg: (ethernet i210-t1) string to replaced by i210

Processor Total
i210 42

will you all please suggest me how to do. If so send me sample query.

@Venkatesh You may have to write one more sql to aggregate the total

select ‘i210’, sum(Z.total) from
(SELECT processor, SUM(processor) as Total from processor-types where (processor like ‘%i210%’)
and ddate like ‘20161009’ group by processor) Z