SELECT
    kc.vehicle_id,
    LISTAGG(
        kc.key_string,
        ';'
    ) WITHIN GROUP(
    ORDER BY
        kc.key_code_usage_id
    ) AS object_key_strings
FROM
    key_code kc
WHERE kc.key_string NOT LIKE '%http%'
AND kc.key_string IS NOT NULL
AND kc.vehicle_id IS NOT NULL
GROUP BY
    kc.vehicle_id;