消费次数达到一定次数，然后其中某一次消费>=1000 该怎么用语句。。
谢谢大佬
select b.StoreID 店铺,Name 姓名,wxName 微信名,year(getdate())-year(BirthDate) 年龄,CellPhone,COUNT(BillNo) 消费次数 ,b.CardID from Members as a
inner join Cards as b on a.MemberID=b.MemberID
inner join MemberBills as c on b.CardID=c.CardID
where b.StoreID like ('NJ%') and c.CreateDateTime between '2019-01-01' and '2019-12-31'
GROUP BY b.StoreID,Name,wxName,BirthDate,CellPhone,b.CardID
HAVING COUNT(BillNo)>=12
ORDER BY b.StoreID,年龄 DESC

次数已经统计好了 ，就是其中某次消费大于等于1000不知道该用什么语句了

如果是消费金额Amount >=1000,那么次数就会被减少了 。

你不都会了么，用having max(Amount)>=1000.0不就行了