I would like to display a running total of Invoice\_Amount. Here is my current query:

```
SELECT cust_name, COUNT(*) as Invoice_Amount, Invoice.invoice_date
FROM Customer, Invoice
WHERE Customer.customer_id = Invoice.customer_id
GROUP BY Invoice.customer_id, Customer.cust_name,invoice_date;

```

and here is the current output:

```
cust_name                   Invoice_Amount        invoice_date
Company A                   1                     2000-10-12 00:00:00.000
Company B                   1                     2000-09-22 00:00:00.000
Company C                   1                     2000-05-26 00:00:00.000
Company D                   1                     2000-08-15 00:00:00.000
Company E                   1                     2000-11-15 00:00:00.000
Company E                   1                     2000-05-02 00:00:00.000

```

Where I would like the Invoice\_Amount in both cases to read 2 like so:

```
cust_name                   Invoice_Amount        invoice_date
Company A                   1                     2000-10-12 00:00:00.000
Company B                   1                     2000-09-22 00:00:00.000
Company C                   1                     2000-05-26 00:00:00.000
Company D                   1                     2000-08-15 00:00:00.000
Company E                   2                     2000-11-15 00:00:00.000
Company E                   2                     2000-05-02 00:00:00.000

```

This is so I can eventually do something along the lines of:

```
HAVING (COUNT(*) > 1)

```

How would I go about getting to this result