select 'action' as x, 10000000 as number

union all

select 'ac' as x, 2000000000 as number

SELECT

*,

CASE

WHEN ABS(number) >= 1e9 THEN ROUND(number / 1e9, 2) || 'B'

WHEN ABS(number) >= 1e6 THEN ROUND(number / 1e6, 2) || 'M'

WHEN ABS(number) >= 1e3 THEN ROUND(number / 1e3, 2) || 'K'

ELSE CAST(number AS VARCHAR)

END AS formatted_number

FROM temp;