56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT
SUM(a.gjs_score) as score,
a.gjs_vl,
b.gji_start,
b.gji_end
FROM
nct_gj_line_alarm_sub a
JOIN nct_gj_line_alarm_interval b ON b.gji_lid = 1
AND a.gjs_mileage >= b.gji_start and
a.gjs_mileage < b.gji_end
GROUP BY
b.gji_start,
b.gji_end,
a.gjs_vl
ORDER BY
b.gji_end,
a.gjs_vl