-1. List the customer id and the name for each customer using two columns. The customer id will be in the first column. Create a concatenation for the second column that combines the title. first name, and last name for each customer. For example, the name for curtomo ID 29485 will display in one colunas Ils. Catherine Abel Don't forget to include a space between each part of the name. Assign Customer Name as the alias for the derived column. Order the results in alphabetical order by last namo then by first nare. QUESTION What is the Customer Nane with the Customer ID of 294897 YOUR ANSVER: I ctD 2. Using the CAST function. list the customer ID and the name for each customer in one column. Create a concatenation of the customer id title, first name and last name for each customer. Por example, the record for customer id 29485 will display in one colun us 29485. Ms. Catherine Abel Assign Customer Into as the alias for the derived column. Order the results in alphabetical order by last name then by first nine. HINT: Look at the data type of the fields to which you are concatenating the customer id and cast customer id to match. QUESTION What is the value for Customer into in row 6? YOUR ANSVER -1. List the customer id and the name for each customer using two columns. The customer id will be in the first column. Create a concatenation for the second column that combines the title. first name, and last name for each customer. For example, the name for curtomo ID 29485 will display in one colunas Ils. Catherine Abel Don't forget to include a space between each part of the name. Assign Customer Name as the alias for the derived column. Order the results in alphabetical order by last namo then by first nare. QUESTION What is the Customer Nane with the Customer ID of 294897 YOUR ANSVER: I ctD 2. Using the CAST function. list the customer ID and the name for each customer in one column. Create a concatenation of the customer id title, first name and last name for each customer. Por example, the record for customer id 29485 will display in one colun us 29485. Ms. Catherine Abel Assign Customer Into as the alias for the derived column. Order the results in alphabetical order by last name then by first nine. HINT: Look at the data type of the fields to which you are concatenating the customer id and cast customer id to match. QUESTION What is the value for Customer into in row 6? YOUR ANSVER