-- Preserve customer QA output semantics for empty numeric aggregates.

UPDATE sg_qa_vector_example
   SET answer_text = NVL(answer_text, '') || ' For this approved metric, normalize an empty numeric aggregate to 0 in the returned result. Preserve the template join from CZN_CUSTOM_GOODS_CHANGE_TXN to CZN_COMN_USER_MST, apply u.EXPT_USER_YN=''N'', and count distinct u.GUID.',
       inspection_note = 'Customer QA verified: empty total Ether usage is reported as numeric zero with the template user-master join, excluded-user filter, and user population.',
       verified_at = SYSTIMESTAMP,
       verified_by = 'SGMP_POC_METADATA_REVIEW'
 WHERE source_type = 'CUSTOMER_QA_BENCHMARK'
   AND source_case_id = 'CZN-13';

COMMIT;