You use a SQL function to instruct the database to combine the two columns into a new column called “address.” The syntax is: JOIN(street_address, ” to “, unit) as address.

Correct
To combine the two columns into a new column called “address,” the syntax is: CONCAT(street_address, " to ", unit) as address.