SELECT CONCAT(city, ', ', state) AS address FROM customers CONCAT() ➔ Creates a new collumn called 'address' with the pattern ''city, state".