SELECT distinct b.用户名称,
状态=
CASE
WHEN RIGHT(b.完成情况,1)='1' THEN '完成'
WHEN RIGHT(b.完成情况,1)='0' THEN '未完成'
END,
SUM(b.计划数) AS 计划数
FROM b
GROUP BY b.用户名称,RIGHT(b.完成情况,1)
状态=
CASE
WHEN RIGHT(b.完成情况,1)='1' THEN '完成'
WHEN RIGHT(b.完成情况,1)='0' THEN '未完成'
END,
SUM(b.计划数) AS 计划数
FROM b
GROUP BY b.用户名称,RIGHT(b.完成情况,1)
状态=
CASE
WHEN RIGHT(b.完成情况,1)='1' THEN '完成'
WHEN RIGHT(b.完成情况,1)='0' THEN '未完成'
END,
SUM(b.计划数) AS 计划数
FROM b
GROUP BY b.用户名称,RIGHT(b.完成情况,1)