Aggregation
是必需的,因为您无权访问别名 total_calories
SELECT type,SUM(calories) AS total_calories
FROM exercise_logs
GROUP BY type
HAVING SUM(calories) > 150;
使用HAVING时出现“无效的列名”
Aggregation
是必需的,因为您无权访问别名 total_calories
SELECT type,SUM(calories) AS total_calories
FROM exercise_logs
GROUP BY type
HAVING SUM(calories) > 150;