out_fee / in_min 没有聚合!改成这样:SELECT '2', 'out', SUM(piece), 0, SUM(out_min), 0, SUM(out_fee), 0,
SUM(out_fee) / SUM(in_min)
FROM (SELECT name, type, SUM(piece) AS piece, area,
in_min = SUM(CASE WHEN type LIKE '%in%' THEN [min] ELSE 0 END),
out_min = SUM(CASE WHEN type LIKE '%out%' THEN [min] ELSE 0 END),
in_fee = SUM(CASE WHEN type LIKE '%in%' THEN [fee] ELSE 0 END),
out_fee = SUM(CASE WHEN type LIKE '%out%' THEN [fee] ELSE 0 END)
FROM sourcedetail
GROUP BY [name], type, area) aa
WHERE type = 'out' AND area LIKE '%china%'
SUM(out_fee) / SUM(in_min)
FROM (SELECT name, type, SUM(piece) AS piece, area,
in_min = SUM(CASE WHEN type LIKE '%in%' THEN [min] ELSE 0 END),
out_min = SUM(CASE WHEN type LIKE '%out%' THEN [min] ELSE 0 END),
in_fee = SUM(CASE WHEN type LIKE '%in%' THEN [fee] ELSE 0 END),
out_fee = SUM(CASE WHEN type LIKE '%out%' THEN [fee] ELSE 0 END)
FROM sourcedetail
GROUP BY [name], type, area) aa
WHERE type = 'out' AND area LIKE '%china%'
谢谢了。
收分吧。