Thank you for all the help with the table structure. However I am still looking for an answer to my original question - how can I query to find the...

CREATE TABLE [dbo].[Games] (

[Game_ID] INT IDENTITY (1, 1) NOT NULL,

...

CREATE TABLE [dbo].[Games] (

[Game_ID] INT IDENTITY (1, 1) NOT NULL,

...

Since you want to criticize my table structure and imply that I am doing this for a school project and am therefore cheating, here is the actual table structure:

USE [DB_75956_cd]

GO

/******...

I will have to look into it. I understand everything except the "ROW_NUMBER() OVER( ORDER BY GameDate) -

ROW_NUMBER()...

Thank you very much

The Games Table:

CREATE TABLE [dbo].[Games](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Lge] [nvarchar](255) NULL,

[GameDate] [date] NULL,

[HomeTeam] [nvarchar](255) NULL,

[Home_Score] [float] NULL,

[AwayTeam] [nvarchar](255) NULL,

[Away_Score] [float] NULL)

INSERT INTO [dbo].[Games2]

...