SELECT CONCAT(city, ', ', state) AS address FROM customers       

CONCAT() ➔ Creates a new collumn called ‘address’ with the pattern “city, state”.