Fix Names in a Table

Given a Users table (user_id, name), write a query to normalize each name so only the first character is uppercase and the rest are lowercase, and return the rows ordered by user_id.