ORDER BY on field that isn't in a SELECT using DISTINCT or GROUP BY to get distinct records
Actually, did manage to figure it out with:

SELECT
    code,
    title,
    country,
    MIN(sortorder)
FROM
    data_a
GROUP BY
    code,
    title,
    country
ORDER BY
    4