Different teams keep giving me different customer counts, and the seniors are untangling why. Your piece: give me the clean count. The customers table has an is_duplicate column that flags bad rows. Count the customers where is_duplicate is false. That single number is the foundation everything else gets compared against.