如何为查询语句重新标注状态

预期结果
sNo rtime zt
1001 2021-08-26 10:00:00.000 进行中
1002 2021-08-27 10:00:00.000 完成
1003 2021-08-28 10:00:00.000 待操作
img

img

select a.Sno,a.rtime,(case when ifnull(qty,0)-ifnull(cty,0)=0 then '完成' when ifnull(qty,0)-ifnull(cty,0)=ifnull(qty,0) then '待操作' else '进行中' end ) as zt,ifnull(qty,0),ifnull(cty,0) from (select Sno,SUM(cty) as qty,rtime  from xx GROUP BY Sno,rtime) a LEFT join (select Sno,sum(qty) as cty  from tt GROUP BY Sno) b ON a.Sno=b.Sno

结果如下：
img

img

img

如有帮助，望采纳！谢谢! 点击我这个回答右上方的【采纳】按钮

状态的判断依据是什么？