AiDOPWarehouse/doc/plan/sql/uat-data/_tmp_verify_final.sql

SELECT tenant_id,factory_id,module_code,metric_code,metric_value,biz_date,calc_time
FROM ado_s9_kpi_value_l1_day
WHERE tenant_id IN (838257186181189,838257212780613,838257237606469)
  AND factory_id=1
  AND metric_code IN ('S1_L1_004','S3_L1_004','S9_L1_001')
  AND is_deleted=0
ORDER BY tenant_id,metric_code,biz_date DESC;

SELECT tenant_id,module_code,
       COUNT(DISTINCT metric_code) metric_count,
       SUM(metric_value IS NOT NULL) valued_count,
       MAX(biz_date) latest_biz_date
FROM ado_s9_kpi_value_l1_day
WHERE tenant_id IN (838257186181189,838257212780613,838257237606469)
  AND factory_id=1 AND is_deleted=0 AND is_active=1
GROUP BY tenant_id,module_code
ORDER BY tenant_id,module_code;