USE Games

DECLARE @GameID AS INT
DECLARE @Date AS DATE
DECLARE @LicenseKey AS VARCHAR(255)
DECLARE @Game AS VARCHAR(255)
DECLARE @Platform AS VARCHAR(50)

SET @LicenseKey = 'ABCDE-FGHIJ-KLMNO'
SET @Game = 'Gee 2: Gee Two Gee'
SET @Platform = 'Steam'

IF NOT EXISTS
(
    SELECT GameName
    FROM Games
    WHERE GameName = @Game
)
    BEGIN
        INSERT INTO Games (GameName)
        VALUES (@Game);
        END;

SET @GameID = (
    SELECT GameID
FROM Games
WHERE GameName = @Game
);

SET @Date = (
    SELECT GETDATE()
    );

INSERT INTO LicenseKeys (GameID, DateAcquired, LicenseKey,Used,Platform)
VALUES
(@GameID,@Date,@LicenseKey,'No',@Platform);