-- Verifica os tipos de dados da coluna Driver_ID 
SELECT table_name,
    column_name,
    data_type
FROM `ifood-prev-fraude-case.fraude_biometria`.INFORMATION_SCHEMA.COLUMNS
WHERE column_name = 'Driver_ID';

-- Verifica valores não numéricos em Driver_ID
SELECT DISTINCT Driver_ID
FROM `ifood-prev-fraude-case.fraude_biometria.orders`
WHERE NOT REGEXP_CONTAINS(Driver_ID, r'^\d+$');

-- Verifica quantos Driver_ID são iguais a "#N/D"
SELECT COUNT(*) AS count_invalid_driver_id
FROM `ifood-prev-fraude-case.fraude_biometria.orders`
WHERE Driver_ID = '#N/D';