-- Spanish Primera Division -- Results from 2009/2010 season -- Expected result: --Position Team P W D L F A Points ---------------------- -------------------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- --1 Barcelona 38 31 6 1 98 24 99 --2 Real Madrid 38 31 3 4 102 35 96 --3 Valencia 38 21 8 9 59 40 71 --4 Sevilla 38 19 6 13 65 49 63 --5 Mallorca 38 18 8 12 59 44 62 --6 Getafe 38 17 7 14 58 48 58 --7 Villarreal 38 16 8 14 58 57 56 --8 Ath Bilbao 38 15 9 14 50 53 54 --9 Ath Madrid 38 13 8 17 57 61 47 --10 La Coruna 38 13 8 17 35 49 47 --11 Espanol 38 11 11 16 29 46 44 --12 Osasuna 38 11 10 17 37 46 43 --13 Almeria 38 10 12 16 43 55 42 --14 Zaragoza 38 10 11 17 46 64 41 --15 Sp Gijon 38 9 13 16 36 51 40 --16 Santander 38 9 12 17 42 59 39 --17 Malaga 38 7 16 15 42 48 37 --18 Valladolid 38 7 15 16 37 62 36 --19 Tenerife 38 9 9 20 40 74 36 --20 Xerez 38 8 10 20 38 66 34 IF OBJECT_ID(N'dbo.Games', 'U') IS NOT NULL DROP TABLE dbo.Games; IF OBJECT_ID(N'dbo.Teams', 'U') IS NOT NULL DROP TABLE dbo.Teams; CREATE TABLE dbo.Teams ( TeamId int NOT NULL, TeamName varchar(20) NOT NULL ); CREATE TABLE dbo.Games ( HomeId int NOT NULL, VisitorId int NOT NULL, HomeGoals int NOT NULL, VisitorGoals int NOT NULL ); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (1, N'Barcelona'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (2, N'Real Madrid'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (3, N'Valencia'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (4, N'Sevilla'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (5, N'Mallorca'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (6, N'Getafe'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (7, N'Villarreal'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (8, N'Ath Bilbao'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (9, N'Ath Madrid'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (10, N'La Coruna'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (11, N'Espanol'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (12, N'Osasuna'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (13, N'Almeria'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (14, N'Zaragoza'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (15, N'Sp Gijon'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (16, N'Santander'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (17, N'Malaga'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (18, N'Tenerife'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (19, N'Valladolid'); INSERT [dbo].[Teams] ([TeamId], [TeamName]) VALUES (20, N'Xerez'); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 10, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 18, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 19, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 11, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 9, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 20, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 7, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 6, 1, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 4, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 15, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 16, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 2, 0, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 1, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 14, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 17, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 13, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 12, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 3, 2, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 5, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 8, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 9, 5, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 11, 2, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 16, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 18, 4, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 4, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 6, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 7, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 20, 5, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 15, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 19, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 1, 1, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 5, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 13, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 17, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 3, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 8, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 12, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 2, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 10, 0, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 14, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 4, 0, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 1, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 18, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 9, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 16, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 20, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 7, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 19, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 15, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 6, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 14, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 13, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 10, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 12, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 3, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 2, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 5, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 8, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 11, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 17, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 4, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 19, 4, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 1, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 15, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 18, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 13, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 6, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 9, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 7, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 16, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 5, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 11, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 2, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 3, 0, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 14, 6, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 8, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 12, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 20, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 10, 4, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 17, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 9, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 1, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 6, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 4, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 19, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 15, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 3, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 16, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 18, 5, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 13, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 2, 2, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 5, 4, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 10, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 17, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 12, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 8, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 7, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 11, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 14, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 20, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 1, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 9, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 16, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 4, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 6, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 14, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 13, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 3, 1, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 19, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 15, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 17, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 7, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 5, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 8, 1, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 11, 4, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 2, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 20, 5, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 10, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 18, 3, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 12, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 1, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 1, 1, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 13, 4, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 19, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 9, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 3, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 16, 0, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 12, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 14, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 15, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 6, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 11, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 2, 2, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 8, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 10, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 7, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 18, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 5, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 20, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 4, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 17, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 12, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 14, 6, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 6, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 13, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 3, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 5, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 9, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 15, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 16, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 4, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 7, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 11, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 20, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 19, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 8, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 2, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 18, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 17, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 10, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 16, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 9, 0, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 13, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 14, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 12, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 8, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 5, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 6, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 1, 0, 5); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 3, 1, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 2, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 4, 4, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 11, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 18, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 15, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 6, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 10, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 19, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 7, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 20, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 8, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 13, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 1, 0, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 5, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 9, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 17, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 16, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 3, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 14, 4, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 12, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 8, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 2, 1, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 1, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 17, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 16, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 3, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 14, 1, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 13, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 12, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 5, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 6, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 11, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 19, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 15, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 20, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 10, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 7, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 18, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 9, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 4, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 3, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 8, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 2, 0, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 1, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 10, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 13, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 17, 0, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 12, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 14, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 5, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 16, 4, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 20, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 4, 1, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 9, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 18, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 11, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 19, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 7, 6, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 15, 1, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 6, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 17, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 14, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 2, 1, 5); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 3, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 13, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 8, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 12, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 5, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 10, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 11, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 1, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 18, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 4, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 19, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 7, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 20, 2, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 15, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 6, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 9, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 16, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 5, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 10, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 8, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 17, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 3, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 14, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 11, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 2, 1, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 20, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 12, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 6, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 4, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 19, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 15, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 18, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 7, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 9, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 16, 1, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 13, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 1, 2, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 20, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 10, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 14, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 12, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 5, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 7, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 17, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 11, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 8, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 2, 2, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 18, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 1, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 3, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 15, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 6, 1, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 13, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 9, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 4, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 19, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 16, 4, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 8, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 18, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 17, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 5, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 10, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 11, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 2, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 20, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 12, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 7, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 4, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 1, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 19, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 15, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 6, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 13, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 9, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 16, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 3, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 14, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 7, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 18, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 4, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 20, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 10, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 17, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 11, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 5, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 2, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 8, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 1, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 15, 3, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 9, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 14, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 13, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 19, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 3, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 6, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 16, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 12, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 20, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 10, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 2, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 11, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 18, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 4, 4, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 17, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 7, 1, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 19, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 8, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 3, 0, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 14, 0, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 15, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 16, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 6, 0, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 1, 1, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 13, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 5, 1, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 12, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 9, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 7, 4, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 18, 4, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 15, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 20, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 17, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 19, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 2, 1, 4); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 10, 3, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 4, 1, 5); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 11, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (11, 12, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (6, 17, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (10, 5, 1, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (2, 8, 5, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (4, 1, 2, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (15, 9, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (18, 13, 2, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (19, 16, 2, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (7, 3, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (20, 14, 3, 2); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (13, 4, 2, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (8, 10, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (9, 6, 0, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (5, 11, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (14, 7, 3, 3); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (1, 19, 4, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (17, 2, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (12, 20, 1, 1); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (16, 15, 2, 0); INSERT [dbo].[Games] ([HomeId], [VisitorId], [HomeGoals], [VisitorGoals]) VALUES (3, 18, 1, 0); GO