具有having子句错误

MONTH（Date）不是您分组的列，因此它不会出现在Have子句中。您可以这样做：

select SUM (Bill) from ProductSaleReportwhere MonTH(Date) between 1 and 3group by PCI

其他方式是

select SUM (Bill) from ProductSaleReport group by PCI, MonTH(Date) having MonTH(Date) between 1 and 3

但请记住，您将获得按月以及按PCI分组的结果。