7. Buy Items for User in Game

INSERT INTO UsersGames ( GameId, UserId,CharacterId ,Level,JoinedOn, Cash)
VALUES( (
SELECT G.ID FROM Games  g where g.Name='Edinburgh'),(
SELECT U.Id FROM Users U WHERE  u.Username='Alex'), '','',GETDATE(),


(SELECT SUM(ii.Price)  FROM Items ii
WHERE II.Id IN(
SELECT Id FROM Items  WHERE Name IN('Blackguard', 'Bottomless Potion of Amplification',
'Eye of Etlich (Diablo III)', 'Gem of Efficacious Toxin', 'Golden Gorget of Leoric',
'Hellfire Amulet'))
)
)