← All practice problems

BI vs Finance — customer-list reconciliation

working · sql🔒Walkthroughs

NEW

BI vs Finance — customer-list reconciliation

BI and Finance each maintain a customer list. They disagree. Quantify the overlap in a single row with three counts:

only_bi: customers in BI but not Finance
only_fin: customers in Finance but not BI
in_both: customers in both

Hint: UNION ALL/EXCEPT/INTERSECT can each produce one of the three numbers; subqueries against them slot into a single SELECT.

Tables & sample data

bi_customers

Loading preview…

fin_customers

Loading preview…

query.sql

Loading…

Loading editor…