消费次数达到一定次数，然后其中某一次消费>=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
谢谢大佬
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
