How to write such a query to the table?

Question

MySQL

There is a forms table
id count_forms
1 800
2 900
3 10
4 60
5 596
You need to make the following query:
Select id from the forms table where SUM(count_forms) is greater than 1000.
BUT the sum should be closest to 1000.

SELECT id, SUM(count_forms) as sum_count_forms FROM forms WHERE sum_count_forms>1000

does not work.

Answer 1

Use HAVING.
More or less like this:

SELECT id, SUM(count_forms) as sum_count_forms 
FROM forms 
HAVING sum_count_forms > 1000
ORDER BY sum_count_forms ASC
LIMIT 1

Answer 2

Is the task set correctly? If we have one table, then the sum function will simply sum all the values ​​\u200b\u200band give the final amount. And then it will be compared with 1000. Is there a grouping in the table?