How to write a query with a condition and GROUP BY in MySQL?

Question

MySQL

Greetings. I am writing this query:

SELECT reklama_source_id, SUM(price) as `sum_price` FROM `applications` WHERE `sum_price` > 20 GROUP BY `reklama_source_id`

I want to select advertising sources that have generated more than 20 income,
but the database swears with an error:

#1054 - Неизвестный столбец 'sum_price' в 'where clause'

How to make a request?

Answer 1

On WHERE this column is not defined yet, it appears only after GROUP BY. Use HAVING.