CODE EXAMPLE FOR SQL

group concat with separator

SELECT 
    GROUP_CONCAT(DISTINCT country
        ORDER BY country
        SEPARATOR ';')
FROM
    customers;