Untitled
user_3592770
plain_text
20 days ago
681 B
4
Indexable
-- 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;
Editor is loading...
Leave a Comment