SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'CHG' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'CTK' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'DST' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'FWB' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'H17' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'H23' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'HHH' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'HJT' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'HKE' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'HKP' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'HWK' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'JBR' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'KKC' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'KLK' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'KMS' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'KTA' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'KWT' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'LKP' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'LYC' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'MPK' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'PQK' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'PTP' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'RDG' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'SKB' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'SKC' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'SKM' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'SKR' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'SPG' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'WWK' GROUP BY oid
SELECT oid, COUNT(DISTINCT reg) AS 'total_counter', COUNT(DISTINCT CASE WHEN  tx_type = 'ZR' THEN reg END) AS 'total_zreport'
										FROM trans_journal WHERE SUBSTR(c_dd,1,10) = '2025-08-02'  AND oid !='ZZ' AND oid = 'ZHK' GROUP BY oid