aristillus
8/30/2017 - 3:14 PM

Запрос с условием по сумме. Оператор HAVING

Запрос с условием по сумме. Оператор HAVING

SELECT type, SUM(calories) AS total_calories FROM exercise_logs
    GROUP BY type
    HAVING total_calories > 150
    ;