T-SQL queries for data with a column with a total value greater than X

Original: https://www.lesg.cn/netdaima/sqlservert-sql/2016-459.html

Today, the operation of the query encountered a request such as:

There is a table

User ID	Date of purchase	Purchase Amount	Purchase status
1	2016-10-12	100	1
2	2016-11-12	10	1
2	2016-11-15	100	1

Need to check out 11-12 to 11-15 period, the total purchase amount is greater than 105;

Query SQL as follows (need to use the having function)

Select User ID,Sum(purchase amount) from    twhere buy date >=' 2016-11-12 '  and purchase date <='2016-11-15 23:59 59.00'group  by havesum>

T-SQL queries for data with a column with a total value greater than X