• Creating a custom column use the keyword CONCAT -
  SELECT CONCAT(city,',',state) FROM customers
• Give name to the new custom column -
  SELECT CONCAT(city,',',state) AS new_info FROM customers