使用
HAVINg错误消息提示的，要求输入
GROUP BY：
SELECt SUM(M1.InvoiceTotal)-SUM(M1.AmountApplied) as PastDueAmount, M1.BillingID, M2.Name, M2.DelinquentDaysThreshold, M2.DelinquentAmountThreshold, DATEDIFF(d, MIN(BillingDate),GETDATE()) as DaysLateFROM Invoices M1 LEFT JOIN ClientAccounts M2 ON M1.BillingID = M2.IDWHERe InvoiceTotal <> AmountApplied AND M2.DelinquentDaysThreshold > DATEDIFF(d, MIN(BillingDate),GETDATE())GROUP BY M1.BillingID, M2.Name, M2.DelinquentDaysThreshold, M2.DelinquentAmountThreshold, DATEDIFF(d, MIN(BillingDate),GETDATE())HAVINg (SUM(M1.InvoiceTotal)-SUM(M1.AmountApplied)) > M2.DelinquentAmountThreshold
