I have a table known as payment plans, I need to get the result set as in the below table. 

```
CREATE TABLE PaymentPlans
(
PaymentPlanID           int, 
EmployeeID              int,        
PaidToDate              money
)

INSERT INTO PaymentPlans VALUES (1,1,100)
INSERT INTO PaymentPlans VALUES (2,1,200)
INSERT INTO PaymentPlans VALUES (3,1,150)

```

In my select query, i need an extra column which provides me the sum of 'PaidToDate'. I'm trying with the below query, where i'm getting the result set for 'Total amount paid', same as 'Paid to date'.

```
SELECT PaymentPlanID, EmployeeID, PaidToDate, SUM(PaidToDate) AS 'TOTAL AMOUNT PAID' FROM PaymentPlans group by PaymentPlanID, EmployeeID, PaidToDate

SELECT a.PaymentPlanID, a.EmployeeID, a.PaidToDate, SUM(a.PaidToDate) AS 
'TOTAL AMOUNT PAID' FROM (
SELECT PaymentPlanID, EmployeeID, PaidToDate FROM PaymentPlans
)a
GROUP BY a.PaymentPlanID, a.EmployeeID, a.PaidToDate

```

On both these scenarios, I'm getting the result as below,

```
PaymentPlanID   EmployeeID  PaidToDate  TotalAmountPaid
1               1           100.00      100.00
2               1           200.00      200.00
3               1           150.00      150.00

```

Where as i need result as below,

```
PaymentPlanID EmployeeID    PaidToDate    TotalAmountPaid
1             1             100.00        450.00
2             1             200.00        450.00
3             1             150.00        450.00

```

Please let me know what am i missing in my query.