Untitled

-- Check CallTypeCode distribution for non-NULL CDIs
SELECT 
    CallTypeCode,
    COUNT(DISTINCT CDI) as distinct_cdis,
    COUNT(*) as total_rows
FROM `p-cdh`.primaryactive.dialer
WHERE CDI IS NOT NULL
GROUP BY CallTypeCode
ORDER BY distinct_cdis DESC;

-- Check if all non-NULL CallTypeCode values are 'INBOUND'
SELECT DISTINCT CallTypeCode
FROM `p-cdh`.primaryactive.dialer
WHERE CDI IS NOT NULL
AND CallTypeCode IS NOT NULL;

-- Verify NULL CallTypeCode counts
SELECT 
    COUNT(DISTINCT CDI) as cdis_with_null_type,
    COUNT(DISTINCT CASE WHEN CallTypeCode IS NULL THEN CDI END) as null_type_cdis
FROM `p-cdh`.primaryactive.dialer
WHERE CDI IS NOT NULL;