sqlh7.1

-- Oefening 1

SELECT vend_name + ' (' + vend_country + ') '
FROM Vendors
ORDER BY vend_name;

-- Oefening 2

SELECT RTRIM(vend_name) + ' (' + RTRIM(vend_country) + ') '
FROM Vendors
ORDER BY vend_name;

-- Oefening 3

SELECT RTRIM(vend_name) + ' (' + RTRIM(vend_country) + ') '  AS vend_title
FROM Vendors
ORDER BY vend_name;