The statement below changes the amount column name to no column mame how can you change the column name or what is a different way to write the statement in SQL so it displays the amount column as money
SELECT Contract_ID, Duration, Expiration_Date, '
+ CONVERT (VARCHAR(20), CONVERT (MONEY, Amount)) FROM Contract;