SELECT
    TO_LIC
FROM V_TRANS
WHERE NO > '287239820'
    AND TO_ZONE LIKE '_A__'
    AND TO_LIC <> 'NULL'
GROUP BY TO_LIC;