个人域名申请的方法_mcu嵌入式软件开发_房地产网站建设_免费发布信息网

select t.* from 
(SELECT"TBDW" ,SUM(CASE WHEN "NY" = '2025-01' THEN  CAST("ZFYHTS" AS numeric)  ELSE 0 END) AS "01重复隐患条数",SUM(CASE WHEN "NY" = '2025-01' THEN  CAST("YHZTS" AS numeric)  ELSE 0 END) AS "01隐患总条数",SUM(CASE WHEN "NY" = '2025-01' THEN  CAST("ZFFSL" AS numeric)  ELSE 0 END) AS "01重复发生率",SUM(CASE WHEN "NY" = '2025-02' THEN  CAST("ZFYHTS" AS numeric)  ELSE 0 END) AS "02重复隐患条数",SUM(CASE WHEN "NY" = '2025-02' THEN  CAST("YHZTS" AS numeric)  ELSE 0 END) AS "02隐患总条数",SUM(CASE WHEN "NY" = '2025-02' THEN  CAST("ZFFSL" AS numeric)  ELSE 0 END) AS "02重复发生率",SUM(CASE WHEN "NY" = '2025-03' THEN  CAST("ZFYHTS" AS numeric)  ELSE 0 END) AS "03重复隐患条数",SUM(CASE WHEN "NY" = '2025-03' THEN  CAST("YHZTS" AS numeric)  ELSE 0 END) AS "03隐患总条数",SUM(CASE WHEN "NY" = '2025-03' THEN  CAST("ZFFSL" AS numeric)  ELSE 0 END) AS "03重复发生率",SUM(CAST("ZFYHTS" AS numeric)) AS "1-本月累计重复隐患",SUM(CAST("YHZTS" AS numeric)) AS "1-本月累计隐患",CAST(SUM(CAST("ZFYHTS" AS numeric))/SUM(CAST("YHZTS" AS numeric)) as DECIMAL(10,2)) AS "1-本月累计"FROM "JT_ZFYHSB"  WHERE TO_DATE("NY", 'YYYY-MM-DD') BETWEEN '2025-01-01' AND '2025-04-30'GROUP BY "TBDW"
) t