From c3354fc0c4a659f02e061d63327eeef345d91059 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 27 九月 2026 16:13:48 +0800
Subject: [PATCH] docs(交接): HANDOFF 增补本次清空的 7 列草稿列对照表(页签/列/格数/原表头/公式语义/清空前缓存值/引用数=0，附中口径明细!AB=2025年4月不可清的对照)
---
docs/生成汇总大表/同名企业_1-8月累计对比_2026-09-19.sql | 121 ++++++++++++++++++++++++----------------
1 files changed, 72 insertions(+), 49 deletions(-)
diff --git "a/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql" "b/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql"
index 7fd1adc..be8d051 100644
--- "a/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql"
+++ "b/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/\345\220\214\345\220\215\344\274\201\344\270\232_1-8\346\234\210\347\264\257\350\256\241\345\257\271\346\257\224_2026-09-19.sql"
@@ -16,28 +16,50 @@
-- 2025 骞� 1-8 鏈堟湁 664 瀹朵紒涓氥��2026 骞� 1-8 鏈堝彧鏈� 636 瀹讹紝
-- 鐩存帴鎷夸袱骞存�绘暟鐩稿噺锛屽樊棰濋噷娣风潃銆屼紒涓氭暟閲忓彉浜嗐�嶇殑褰卞搷锛屼笉鏄湡瀹炲鍑忋��
-- 鎶婁袱骞撮兘鎶ラ�佽繃鐨勪紒涓氬悕绉板彇浜ら泦锛堝疄娴� 545 瀹讹級锛屼袱骞寸殑浼佷笟鑼冨洿鎵嶄竴鑷淬��
--- 瀹炴祴缁撴灉锛堝悓鍚嶄紒涓氬彛寰� 545 瀹讹級锛�
--- 2025 骞� 1-8 鏈堬細璐ц繍閲� 30153.14 涓囧惃锛屽懆杞噺 4635340.46 涓囧惃鍏噷
--- 2026 骞� 1-8 鏈堬細璐ц繍閲� 27752.68 涓囧惃锛屽懆杞噺 4389882.05 涓囧惃鍏噷
--- 鍚屾瘮锛氳揣杩愰噺 -7.96%锛屽懆杞噺 -5.30%
+-- 瀹炴祴缁撴灉锛堝悓鍚嶄紒涓氬彛寰� 545 瀹讹紝4 浣嶅皬鏁帮級锛�
+-- 2025 骞� 1-8 鏈堬細璐ц繍閲� 30153.1392 涓囧惃锛屽懆杞噺 4635340.4627 涓囧惃鍏噷
+-- 2026 骞� 1-8 鏈堬細璐ц繍閲� 27752.6820 涓囧惃锛屽懆杞噺 4389882.0468 涓囧惃鍏噷
+-- 鍚屾瘮锛氳揣杩愰噺 -7.9609%锛屽懆杞噺 -5.2954%
+-- 锛�2026 骞磋繖涓や釜鏁颁笌銆婃寔缁湪瑙勪紒涓�545瀹禵鍒嗗競宸�1-8鏈堢疮璁¤繍璺濆強鍚屾瘮銆嬩氦浠樹欢鐨勫叏鐪佽瀹屽叏涓�鑷达級
-- ============================================================
+
+-- ============================================================
+-- 鈽� 灏忔暟浣嶇害瀹氾紙2026-09-19 琛ュ厖锛屽緢閲嶈锛夆槄
+-- ------------------------------------------------------------
+-- 1) 琛ㄩ噷瀛樼殑鏄�屽惃 / 鍚ㄥ叕閲屻�嶇殑鏁存暟锛屽鍑烘椂 梅10000 鍙樻垚銆屼竾鍚� / 涓囧惃鍏噷銆嶃��
+-- 2) 鍑℃槸銆愯鎷垮幓浜屾璁＄畻銆戠殑鍒楋紙灏ゅ叾鏄�屽懆杞噺 梅 璐ц繍閲� = 骞冲潎杩愯窛銆嶏級锛�
+-- 鍗冧竾涓嶈兘鍦� SQL 閲屽彧淇濈暀 2 浣嶅皬鏁帮紒
+-- 鍘熷洜锛氫繚鐣� 2 浣� = 绮惧害鍒� 100 鍚ㄣ�傚璐ц繍閲忓彧鏈夊嚑鍗冨惃鐨勫皬浼佷笟锛�
+-- 鍒嗘瘝浼氳鐮嶆帀鏈�澶� 1%锛岀畻鍑烘潵鐨勮繍璺濊兘宸嚭濂藉嚑鍏噷銆�
+-- 瀹炰緥锛氭箹鍖楀紭闆风墿娴佹湁闄愬叕鍙� 2026 骞� 1-8 鏈堣揣杩愰噺 4631 鍚�
+-- 鈫� 涓嶅彇鏁� 0.4631 涓囧惃锛堣繍璺� 1267.05 鍏噷锛屾纭級
+-- 鈫� 鍙� 2 浣� 0.46 涓囧惃锛堣繍璺� 1275.59 鍏噷锛岃櫄楂� 8.53 鍏噷锛�
+-- 3) 鎵�浠ユ湰鑴氭湰绾﹀畾锛�
+-- 路 鏄庣粏绫绘煡璇紙鏌ヨ 2銆佹煡璇� 7锛夆啋 瀹屽叏涓嶅 ROUND锛屽鍑哄嵆鍘熷鍊�
+-- 锛堣揣杩愰噺/鍛ㄨ浆閲忕殑鍘熷鍊兼渶澶� 4 浣嶅皬鏁帮紝灏辨槸鍏ㄧ簿搴︼紱鍚屾瘮鍒楀皬鏁颁綅杈冮暱锛�
+-- 瀚岄暱鍙嚜琛屽湪澶栭潰濂� ROUND(...,2)锛夛紱
+-- 路 姹囨�荤被锛堟煡璇� 1銆�3銆�5銆�8锛夆啋 鍚屾牱淇濈暀 4 浣嶅皬鏁帮紙瀵规湰琛ㄦ暟鎹潵璇� 4 浣嶅氨鏄叏绮惧害锛�
+-- 淇濈暀 2 浣嶆病鏈変换浣曞ソ澶勶紝鍙嶈�屼細璁╀汉璇互涓烘暟鎹氨鍙湁 2 浣嶇簿搴︼級锛�
+-- 路 濡傛灉浣犺鑷繁绠楄繍璺�/鍚屾瘮锛屽缓璁洿鎺ョ敤鏌ヨ 7锛屾垨鎶� /10000 閭ｄ竴灞傚幓鎺夛紝
+-- 鍏堝湪 Excel 閲屾寜銆屽惃銆嶇畻瀹屽啀闄ゃ��
+-- ============================================================
-- =====================================================================
-- 鏌ヨ 1锛氭眹鎬讳竴琛� 鈥斺�� 鍚屽悕浼佷笟鍙ｅ緞鐨勪袱骞寸疮璁℃暟 + 鍚屾瘮澧為��
-- =====================================================================
SELECT COUNT(DISTINCT e.enterprise_name) AS 浼佷笟鏁�,
ROUND(SUM(CASE WHEN e.report_period <= '2025-08'
- THEN e.freight_total ELSE 0 END) / 10000, 2) AS 璐ц繍閲�2025_涓囧惃,
+ THEN e.freight_total ELSE 0 END) / 10000, 4) AS 璐ц繍閲�2025_涓囧惃,
ROUND(SUM(CASE WHEN e.report_period >= '2026-01'
- THEN e.freight_total ELSE 0 END) / 10000, 2) AS 璐ц繍閲�2026_涓囧惃,
+ THEN e.freight_total ELSE 0 END) / 10000, 4) AS 璐ц繍閲�2026_涓囧惃,
ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
/ NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END), 0) - 1) * 100, 2)
AS 璐ц繍閲忓悓姣擾鐧惧垎姣�,
ROUND(SUM(CASE WHEN e.report_period <= '2025-08'
- THEN e.turnover_total ELSE 0 END) / 10000, 2) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
+ THEN e.turnover_total ELSE 0 END) / 10000, 4) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
ROUND(SUM(CASE WHEN e.report_period >= '2026-01'
- THEN e.turnover_total ELSE 0 END) / 10000, 2) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷,
+ THEN e.turnover_total ELSE 0 END) / 10000, 4) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷,
ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
/ NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END), 0) - 1) * 100, 2)
AS 鍛ㄨ浆閲忓悓姣擾鐧惧垎姣�
@@ -56,20 +78,20 @@
-- 鏌ヨ 2锛氶�愪紒涓氬鐓ф槑缁嗭紙鍚屽悕浼佷笟锛屼袱骞村苟鎺掞級锛屽彲鐩存帴瀵煎嚭 Excel
-- 鎸� 2026 骞磋揣杩愰噺浠庡ぇ鍒板皬鎺掞紱鍘绘帀 ORDER BY 灏辨槸瀹屾暣 545 琛屻��
-- =====================================================================
-SELECT e.enterprise_name AS 浼佷笟鍚嶇О,
- MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END) AS 鍦板尯浠ｇ爜,
- ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END) / 10000, 2) AS 璐ц繍閲�2025_涓囧惃,
- ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END) / 10000, 2) AS 璐ц繍閲�2026_涓囧惃,
- ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
- - SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END)) / 10000, 2) AS 璐ц繍閲忓鍑廮涓囧惃,
- ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
- / NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END), 0) - 1) * 100, 2) AS 璐ц繍閲忓悓姣擾鐧惧垎姣�,
- ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) / 10000, 2) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
- ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) / 10000, 2) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷,
- ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
- - SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END)) / 10000, 2) AS 鍛ㄨ浆閲忓鍑廮涓囧惃鍏噷,
- ROUND((SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
- / NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END), 0) - 1) * 100, 2) AS 鍛ㄨ浆閲忓悓姣擾鐧惧垎姣�
+SELECT e.enterprise_name AS 浼佷笟鍚嶇О,
+ MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END) AS 鍦板尯浠ｇ爜,
+ SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END) / 10000 AS 璐ц繍閲�2025_涓囧惃,
+ SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END) / 10000 AS 璐ц繍閲�2026_涓囧惃,
+ (SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
+ - SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END)) / 10000 AS 璐ц繍閲忓鍑廮涓囧惃,
+ (SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END)
+ / NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END), 0) - 1) * 100 AS 璐ц繍閲忓悓姣擾鐧惧垎姣�,
+ SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) / 10000 AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
+ SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) / 10000 AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷,
+ (SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
+ - SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END)) / 10000 AS 鍛ㄨ浆閲忓鍑廮涓囧惃鍏噷,
+ (SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END)
+ / NULLIF(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END), 0) - 1) * 100 AS 鍛ㄨ浆閲忓悓姣擾鐧惧垎姣�
FROM h2032_enterprise_monthly e
JOIN (SELECT DISTINCT enterprise_name FROM h2032_enterprise_monthly
WHERE report_period BETWEEN '2025-01' AND '2025-08') a
@@ -89,8 +111,8 @@
-- =====================================================================
SELECT t.scope_type AS 鍙ｅ緞,
COUNT(DISTINCT t.enterprise_name) AS 浼佷笟鏁�,
- ROUND(SUM(t.freight_total) / 10000, 2) AS 璐ц繍閲廮涓囧惃,
- ROUND(SUM(t.turnover_total) / 10000, 2) AS 鍛ㄨ浆閲廮涓囧惃鍏噷
+ ROUND(SUM(t.freight_total) / 10000, 4) AS 璐ц繍閲廮涓囧惃,
+ ROUND(SUM(t.turnover_total) / 10000, 4) AS 鍛ㄨ浆閲廮涓囧惃鍏噷
FROM (
SELECT 'ALL_2025' AS scope_type, enterprise_name, freight_total, turnover_total
FROM h2032_enterprise_monthly WHERE report_period BETWEEN '2025-01' AND '2025-08'
@@ -160,10 +182,10 @@
WHEN region_code LIKE '429005%' THEN '娼滄睙' WHEN region_code LIKE '429006%' THEN '澶╅棬'
WHEN region_code LIKE '429021%' THEN '鏋楀尯' ELSE '鍏朵粬' END AS 甯傚窞,
COUNT(DISTINCT d.enterprise_name) AS 鍚屽悕浼佷笟鏁�,
- ROUND(SUM(d.freight_2025) / 10000, 2) AS 璐ц繍閲�2025_涓囧惃,
- ROUND(SUM(d.freight_2026) / 10000, 2) AS 璐ц繍閲�2026_涓囧惃,
- ROUND(SUM(d.turnover_2025) / 10000, 2) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
- ROUND(SUM(d.turnover_2026) / 10000, 2) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷
+ ROUND(SUM(d.freight_2025) / 10000, 4) AS 璐ц繍閲�2025_涓囧惃,
+ ROUND(SUM(d.freight_2026) / 10000, 4) AS 璐ц繍閲�2026_涓囧惃,
+ ROUND(SUM(d.turnover_2025) / 10000, 4) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
+ ROUND(SUM(d.turnover_2026) / 10000, 4) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷
FROM (
SELECT e.enterprise_name,
MAX(CASE WHEN e.report_period >= '2026-01' THEN e.region_code END) AS region_code,
@@ -207,12 +229,13 @@
-- 2025-10 璧峰彨銆屾箹鍖楅暱宄″瘜鐑ㄧ豢鐢典緵搴旈摼鏈夐檺鍏徃銆嶏級锛�
-- 鏌ヨ 2 鎸夊悕绉板尮閰嶄細鎶婅繖瀹朵袱骞撮兘婕忔帀锛屼笖鍚屾椂璁″叆涓ゅ勾銆岀嫭鏈変紒涓氥�嶅悕鍗曘��
-- 杈撳嚭鍒楀凡鎸夊鍑轰範鎯帓濂斤紝鍙洿鎺ョ矘杩� Excel锛涙寜 2026 骞磋揣杩愰噺闄嶅簭銆�
--- 鎻愮ず锛氭槑缁嗚鏄�屽厛鍥涜垗浜斿叆鍐嶆眰鍜屻�嶏紝涓庢煡璇� 8 鐨勫悎璁℃湁 0.01~0.02 鐨勫熬宸紝灞炴甯搞��
+-- 鎻愮ず锛氭槑缁嗗垪涓嶅 ROUND锛堝叏绮惧害锛岃揣杩愰噺/鍛ㄨ浆閲忔渶澶� 4 浣嶅皬鏁帮級锛�
+-- 涓庢煡璇� 8 鐨� 2 浣嶅悎璁′細鏈� 0.01 绾у熬宸紝灞炴甯搞��
-- =====================================================================
-SELECT d.credit_code AS 缁熶竴绀句細淇＄敤浠ｇ爜,
- d.name_2026 AS 浼佷笟鍚嶇О,
- d.name_2025 AS 鍚嶇О2025,
- IF(d.name_2025 <> d.name_2026, '鏄�', '') AS 鏄惁鏀瑰悕,
+SELECT d.credit_code AS 缁熶竴绀句細淇＄敤浠ｇ爜,
+ d.name_2026 AS 浼佷笟鍚嶇О,
+ d.name_2025 AS 鍚嶇О2025,
+ IF(d.name_2025 <> d.name_2026, '鏄�', '') AS 鏄惁鏀瑰悕,
CASE
WHEN d.region_code LIKE '4201%' THEN '姝︽眽' WHEN d.region_code LIKE '4202%' THEN '榛勭煶'
WHEN d.region_code LIKE '4203%' THEN '鍗佸牥' WHEN d.region_code LIKE '4205%' THEN '瀹滄槍'
@@ -222,16 +245,16 @@
WHEN d.region_code LIKE '4212%' THEN '鍜稿畞' WHEN d.region_code LIKE '4213%' THEN '闅忓窞'
WHEN d.region_code LIKE '4228%' THEN '鎭╂柦' WHEN d.region_code LIKE '429004%' THEN '浠欐'
WHEN d.region_code LIKE '429005%' THEN '娼滄睙' WHEN d.region_code LIKE '429006%' THEN '澶╅棬'
- WHEN d.region_code LIKE '429021%' THEN '鏋楀尯' ELSE '鍏朵粬' END AS 甯傚窞,
- d.region_code AS 鍦板尯浠ｇ爜,
- ROUND(d.freight_2025 / 10000, 2) AS 璐ц繍閲�2025_涓囧惃,
- ROUND(d.freight_2026 / 10000, 2) AS 璐ц繍閲�2026_涓囧惃,
- ROUND((d.freight_2026 - d.freight_2025) / 10000, 2) AS 璐ц繍閲忓鍑廮涓囧惃,
- ROUND((d.freight_2026 / NULLIF(d.freight_2025, 0) - 1) * 100, 2) AS 璐ц繍閲忓悓姣擾鐧惧垎姣�,
- ROUND(d.turnover_2025 / 10000, 2) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
- ROUND(d.turnover_2026 / 10000, 2) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷,
- ROUND((d.turnover_2026 - d.turnover_2025) / 10000, 2) AS 鍛ㄨ浆閲忓鍑廮涓囧惃鍏噷,
- ROUND((d.turnover_2026 / NULLIF(d.turnover_2025, 0) - 1) * 100, 2) AS 鍛ㄨ浆閲忓悓姣擾鐧惧垎姣�
+ WHEN d.region_code LIKE '429021%' THEN '鏋楀尯' ELSE '鍏朵粬' END AS 甯傚窞,
+ d.region_code AS 鍦板尯浠ｇ爜,
+ d.freight_2025 / 10000 AS 璐ц繍閲�2025_涓囧惃,
+ d.freight_2026 / 10000 AS 璐ц繍閲�2026_涓囧惃,
+ (d.freight_2026 - d.freight_2025) / 10000 AS 璐ц繍閲忓鍑廮涓囧惃,
+ (d.freight_2026 / NULLIF(d.freight_2025, 0) - 1) * 100 AS 璐ц繍閲忓悓姣擾鐧惧垎姣�,
+ d.turnover_2025 / 10000 AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
+ d.turnover_2026 / 10000 AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷,
+ (d.turnover_2026 - d.turnover_2025) / 10000 AS 鍛ㄨ浆閲忓鍑廮涓囧惃鍏噷,
+ (d.turnover_2026 / NULLIF(d.turnover_2025, 0) - 1) * 100 AS 鍛ㄨ浆閲忓悓姣擾鐧惧垎姣�
FROM (
SELECT e.unified_credit_code AS credit_code,
-- 2026 骞寸敤鐨勫悕瀛楋紙鏀瑰悕鍚庡彇鏂板悕锛夈��2025 骞寸敤鐨勫悕瀛楋紝鐢ㄤ簬鏍囪鏀瑰悕
@@ -255,14 +278,14 @@
-- =====================================================================
-- 鏌ヨ 8锛氭煡璇� 7 鐨勫悎璁¤锛堝鍑烘槑缁嗗悗鐢ㄦ潵瀵规�绘暟锛�546 瀹跺彛寰勶級
--- 2025 骞� 1-8 鏈堬細璐ц繍閲� 30162.99 涓囧惃銆佸懆杞噺 4637038.58 涓囧惃鍏噷
--- 2026 骞� 1-8 鏈堬細璐ц繍閲� 27764.88 涓囧惃銆佸懆杞噺 4392984.81 涓囧惃鍏噷
+-- 2025 骞� 1-8 鏈堬細璐ц繍閲� 30162.9872 涓囧惃銆佸懆杞噺 4637038.5803 涓囧惃鍏噷
+-- 2026 骞� 1-8 鏈堬細璐ц繍閲� 27764.8812 涓囧惃銆佸懆杞噺 4392984.8116 涓囧惃鍏噷
-- =====================================================================
SELECT COUNT(DISTINCT e.unified_credit_code) AS 浼佷笟鏁�,
- ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END) / 10000, 2) AS 璐ц繍閲�2025_涓囧惃,
- ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END) / 10000, 2) AS 璐ц繍閲�2026_涓囧惃,
- ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) / 10000, 2) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
- ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) / 10000, 2) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷
+ ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.freight_total ELSE 0 END) / 10000, 4) AS 璐ц繍閲�2025_涓囧惃,
+ ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.freight_total ELSE 0 END) / 10000, 4) AS 璐ц繍閲�2026_涓囧惃,
+ ROUND(SUM(CASE WHEN e.report_period <= '2025-08' THEN e.turnover_total ELSE 0 END) / 10000, 4) AS 鍛ㄨ浆閲�2025_涓囧惃鍏噷,
+ ROUND(SUM(CASE WHEN e.report_period >= '2026-01' THEN e.turnover_total ELSE 0 END) / 10000, 4) AS 鍛ㄨ浆閲�2026_涓囧惃鍏噷
FROM h2032_enterprise_monthly e
JOIN (SELECT DISTINCT unified_credit_code c FROM h2032_enterprise_monthly
WHERE report_period BETWEEN '2025-01' AND '2025-08') a ON a.c = e.unified_credit_code
--
Gitblit v1.9.1