Project: the query runs, the number is wrong, and finance cannot say why

Diagnose a synthetic revenue query with fan-out, inconsistent status spelling and a timestamp boundary error. Run six datasets, explain masking defects, and write a finance note that separates corrected totals from unverified business assumptions.

~1.5 HOURS · PROJECT · PLUS