select sum(f4) as fa
from (
select f4
from (
select cast(left(f4,len(f4)-2) as int)
from tabcc
) tt
where f3 in ('aaaa','bbbb')
) ttt