How to get all data?

Question

MySQL

Hi everybody!
There is a table:
post (id, name, text, status, sum1, sum2)
I make such a request to calculate the sums of sum1 and sum2. I get the sum_all column and build a query on it.

select *, (sum1 + sum2) AS sum_all from `post` having `sum1` >= 0 and `sum2` <= 90 order by `id` desc

How do I apply where status = 1 here?
I try to do like this:

select *, (sum1 + sum2) AS sum_all from `post` where `status` = 1 having `sum1` >= 0 and `sum2` <= 90 order by `id` desc

But it does not display all records that have status 1, but only those that have the same sum_all. Tell me how to do it right?

Answer 1

move from having to where

Answer 2

where `status` = 1 AND `sum1` >= 0 and `sum2` <= 90