SELECT reward_id, YEAR( MAX( dateupdated ) )
FROM reward_transaction
GROUP BY reward_id