Help With Query Nulls And Addition

Hi I have a query, what I would like to do is create a column that takes the results in two coulms and add them together:

           Col A  Col B Col C

Row1    1          1       2

Row2    2          3       5

Here is the query

declare @t table( player_name varchar(100), BuyIn int, TopUp int, ReBuy int, Winnings int, Events int, Test int)

INSERT INTO @t (player_name, TopUp)

SELECT Player_name, SUM([Top-ups]) AS TOPUPS

FROM (SELECT Event_data.Transaction_type, Players.Player_name, Events.Top_up, Event_data.Transaction_value,

Events.Top_up * Event_data.Transaction_value AS [Top-ups]

FROM Event_data INNER JOIN

Events ON Event_data.Event_id = Events.id INNER JOIN

Players ON Event_data.Player_id = Players.Player_id

WHERE (Event_data.Transaction_type = 2)) AS Topups

GROUP BY player_name

INSERT INTO @t (player_name, ReBuy )

SELECT Player_name, SUM([Re-buys]) AS REBUYS

FROM (SELECT Event_data.Transaction_value, Players.Player_name, Events.Rebuys, Event_data.Transaction_value * Events.Rebuys AS [Re-buys]

FROM Event_data INNER JOIN

Events ON Event_data.Event_id = Events.id INNER JOIN

Players ON Event_data.Player_id = Players.Player_id

WHERE (Event_data.Transaction_type = 3)) AS REBUYS

GROUP BY Player_name

Insert into @t (player_name, BuyIn)

SELECT dbo.Players.Player_name, SUM(dbo.Events.Buy_in) AS BuyIn

FROM dbo.Players INNER JOIN

dbo.Event_data ON dbo.Players.Player_id = dbo.Event_data.Player_id INNER JOIN

dbo.Events ON dbo.Event_data.Event_id = dbo.Events.id

GROUP BY dbo.Players.Player_name, dbo.Event_data.Transaction_type

HAVING (dbo.Event_data.Transaction_type = 1)

ORDER BY SUM(dbo.Events.Buy_in) DESC

 

Insert into @t (player_name, Winnings)

SELECT dbo.Players.Player_name, SUM(dbo.Event_data.Transaction_value) AS Winnings

FROM dbo.Players INNER JOIN

dbo.Event_data ON dbo.Players.Player_id = dbo.Event_data.Player_id

GROUP BY dbo.Players.Player_name, dbo.Event_data.Transaction_type

HAVING (dbo.Event_data.Transaction_type = 1)

insert into @t (player_name, Events)

SELECT dbo.Players.Player_name, COUNT(dbo.Event_data.Place) AS Expr1

FROM dbo.Players INNER JOIN

dbo.Event_data ON dbo.Players.Player_id = dbo.Event_data.Player_id INNER JOIN

dbo.Events ON dbo.Event_data.Event_id = dbo.Events.id

GROUP BY dbo.Players.Player_name

HAVING (NOT (COUNT(dbo.Event_data.Place) IS NULL))

insert into @t (player_name, test)

select player_name, ((TopUp) + (Rebuy)) as Test

from @t

SELECT player_name, min (BuyIn) as BuyIn, min(TopUp) as TopUps, min(ReBuy)as ReBuy, min(Winnings) as Winnings, min(Events) as Events, min(test) as test

FROM @t

GROUP BY player_name

ORDER BY BuyIn DESC

--ORDER BY TOPUPS DESC

 

END

 

 

THis is where I attempt to add the coloms but I get a null result

 

insert into @t (player_name, test)

select player_name, ((TopUp) + (Rebuy)) as Test

from @t

 

any help would be great.