-- Promote the reviewed customer QA example for the NRU metric.

UPDATE sg_qa_vector_example
   SET reference_status = 'APPROVED',
       inspection_status = 'VERIFIED',
       inspection_note = 'Customer QA reviewed: NRU is measured with NRU_FLAG, with the stated date and excluded-user condition.',
       verified_at = SYSTIMESTAMP,
       verified_by = 'SGMP_POC_METADATA_REVIEW'
 WHERE source_type = 'CUSTOMER_QA_BENCHMARK'
   AND source_case_id = 'STD-22';

COMMIT;

SELECT example_id, reference_status, inspection_status, source_case_id
  FROM sg_qa_vector_example
 WHERE source_type = 'CUSTOMER_QA_BENCHMARK'
   AND source_case_id = 'STD-22';
