Data discretization based on rank position
You can use the NTILE() function:

select id, value,
       ntile(2) over (order by value) as normalized
from table_name ;


The 2 means that the values should be split into two buckets, after they are ordered according to the over clause: (ORDER BY value).