select user_id, SUM((case user_dataName when 'X' then USER_DATAVALUE end)) as x,SUM((case user_dataName when 'y' then USER_DATAVALUE end)) as y,
SUM((case user_dataName when 'z' then USER_DATAVALUE end)) as z from table GROUP BY 1 order by 1