Use an INSERT INTO statement with a subquery containing a SQL string function to create user names for the volunteers based on their legal names and insert them into the new table.

SELECT substring(LastName, 1,3) as 'Username' from person - WORKS

SELECT substring(FirstName, 1,3) as 'Username' from person - WORKS

SELECT substring(LastName, 1,3) + '' + substring(FirstName, 1,3) as 'Username' from person - DOES NOT WORK

How can I combine the first two lines to make the last one?