You are working with Azure Synapse Analytics and need to transform data using Transact-SQL (T-SQL). You have a table with customer information, including customer_id, first_name, last_name, and email_address. You need to create a new table that contains only the customer_id and full_name columns, where full_name is a concatenation of first_name and last_name. Which T-SQL query would you use to achieve this?