79766179

Date: 2025-09-16 11:39:56
Score: 2.5
Natty:
Report link

个人想法+大模型：你可以将查询修改如下，使用 coalesce() 函数来处理 NULL 值：

SELECT ROUND(
  coalesce(last_value(LD_ShuiBeng1_DianLiang*40), 0) +
  coalesce(last_value(LDJZ_DianLiang_2*40), 0), 2)
FROM root.building01.aircon.*
WHERE time >= '2025-07-01 00:00:00' AND time <= '2025-08-01 00:00:00'
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • No latin characters (1.5):
  • Low reputation (1):
Posted by: kassusu