展开全部
没见过这个写法,,,
我一般是这样32313133353236313431303231363533e59b9ee7ad9431333332636338写,,,SELECT tt,SUM(population)
FROM
(
SELECT SUM(population) AS population,
(CASE
WHEN country='中国' THEN'亚洲'
WHEN country='印度' THEN'亚洲'
WHEN country='日本' THEN'亚洲'
WHEN country='美国' THEN'北美洲'
WHEN country='加拿大' THEN'北美洲'
WHEN country='墨西哥' THEN'北美洲'
ELSE'其他'END) tt
FROM test
GROUP BY country
) a
GROUP BY tt
你的这种写法,,是SELECT SUM(population) AS population,
(CASE
WHEN country='中国' THEN'亚洲'
WHEN country='印度' THEN'亚洲'
WHEN country='日本' THEN'亚洲'
WHEN country='美国' THEN'北美洲'
WHEN country='加拿大' THEN'北美洲'
WHEN country='墨西哥' THEN'北美洲'
ELSE'其他'END) tt
FROM test
GROUP BY CASE
WHEN country='中国' THEN'亚洲'
WHEN country='印度' THEN'亚洲'
WHEN country='日本' THEN'亚洲'
WHEN country='美国' THEN'北美洲'
WHEN country='加拿大' THEN'北美洲'
WHEN country='墨西哥' THEN'北美洲'
ELSE'其他'END