Does your database have a lookup type function that will translate for you then you can use SUM. This is for Oracle and may not be the best alternative even there.

select sum(decode(total,3,30,6,48,10,50,0)) from table
[download]