使用HAVINg时出现“无效的列名”

使用HAVINg时出现“无效的列名”

Aggregation

是必需的，因为您无权访问别名

total_calories

SELECt   type,SUM(calories) AS total_calories FROM     exercise_logs GROUP BY type HAVINg   SUM(calories) > 150;