CREATE TABLE ##1D ([Week1] [smallint], [Week2] [smallint], [Week3] [smallint], [Week4] [smallint], [Week5] [smallint], [Week6] [smallint], [Week7] [smallint], [Week8] [smallint], [Week9] [smallint], [Week10] [smallint], [Week11] [smallint], [Week12] [smallint], [Week13] [smallint], [Week14] [smallint], [Week15] [smallint], [Week16] [smallint]);CREATE TABLE ##2D ([Week1] [smallint], [Week2] [smallint], [Week3] [smallint], [Week4] [smallint], [Week5] [smallint], [Week6] [smallint], [Week7] [smallint], [Week8] [smallint], [Week9] [smallint], [Week10] [smallint], [Week11] [smallint], [Week12] [smallint], [Week13] [smallint], [Week14] [smallint], [Week15] [smallint], [Week16] [smallint]);CREATE TABLE ##3D ([Week1] [smallint], [Week2] [smallint], [Week3] [smallint], [Week4] [smallint], [Week5] [smallint], [Week6] [smallint], [Week7] [smallint], [Week8] [smallint], [Week9] [smallint], [Week10] [smallint], [Week11] [smallint], [Week12] [smallint], [Week13] [smallint], [Week14] [smallint], [Week15] [smallint], [Week16] [smallint]);CREATE TABLE ##4D ([Week1] [smallint], [Week2] [smallint], [Week3] [smallint], [Week4] [smallint], [Week5] [smallint], [Week6] [smallint], [Week7] [smallint], [Week8] [smallint], [Week9] [smallint], [Week10] [smallint], [Week11] [smallint], [Week12] [smallint], [Week13] [smallint], [Week14] [smallint], [Week15] [smallint], [Week16] [smallint]);DECLARE @Count INTSET @Count = 0WHILE @Count < 1000BEGINWITH RandomD AS (SELECT TOP 1 [Defense] ,[Week1] ,[Week2] ,[Week3] ,[Week4] ,[Week5] ,[Week6] ,[Week7] ,[Week8] ,[Week9] ,[Week10] ,[Week11] ,[Week12] ,[Week13] ,[Week14] ,[Week15] ,[Week16]FROM [dbo].[Defense2014]ORDER BY NEWID())INSERT INTO ##1DSELECT MAX(Week1) ,MAX(Week2) ,MAX([Week3]) ,MAX([Week4]) ,MAX([Week5]) ,MAX([Week6]) ,MAX([Week7]) ,MAX([Week8]) ,MAX([Week9]) ,MAX([Week10]) ,MAX([Week11]) ,MAX([Week12]) ,MAX([Week13]) ,MAX([Week14]) ,MAX([Week15]) ,MAX([Week16])FROM RandomD;WITH Random2 AS (SELECT TOP 2 [Defense] ,[Week1] ,[Week2] ,[Week3] ,[Week4] ,[Week5] ,[Week6] ,[Week7] ,[Week8] ,[Week9] ,[Week10] ,[Week11] ,[Week12] ,[Week13] ,[Week14] ,[Week15] ,[Week16]FROM [dbo].[Defense2014]ORDER BY NEWID())INSERT INTO ##2DSELECT MAX(Week1) ,MAX(Week2) ,MAX([Week3]) ,MAX([Week4]) ,MAX([Week5]) ,MAX([Week6]) ,MAX([Week7]) ,MAX([Week8]) ,MAX([Week9]) ,MAX([Week10]) ,MAX([Week11]) ,MAX([Week12]) ,MAX([Week13]) ,MAX([Week14]) ,MAX([Week15]) ,MAX([Week16])FROM Random2;WITH Random3 AS (SELECT TOP 3 [Defense] ,[Week1] ,[Week2] ,[Week3] ,[Week4] ,[Week5] ,[Week6] ,[Week7] ,[Week8] ,[Week9] ,[Week10] ,[Week11] ,[Week12] ,[Week13] ,[Week14] ,[Week15] ,[Week16]FROM [dbo].[Defense2014]ORDER BY NEWID())INSERT INTO ##3DSELECT MAX(Week1) ,MAX(Week2) ,MAX([Week3]) ,MAX([Week4]) ,MAX([Week5]) ,MAX([Week6]) ,MAX([Week7]) ,MAX([Week8]) ,MAX([Week9]) ,MAX([Week10]) ,MAX([Week11]) ,MAX([Week12]) ,MAX([Week13]) ,MAX([Week14]) ,MAX([Week15]) ,MAX([Week16])FROM Random3;WITH Random4 AS (SELECT TOP 4 [Defense] ,[Week1] ,[Week2] ,[Week3] ,[Week4] ,[Week5] ,[Week6] ,[Week7] ,[Week8] ,[Week9] ,[Week10] ,[Week11] ,[Week12] ,[Week13] ,[Week14] ,[Week15] ,[Week16]FROM [dbo].[Defense2014]ORDER BY NEWID())INSERT INTO ##4DSELECT MAX(Week1) ,MAX(Week2) ,MAX([Week3]) ,MAX([Week4]) ,MAX([Week5]) ,MAX([Week6]) ,MAX([Week7]) ,MAX([Week8]) ,MAX([Week9]) ,MAX([Week10]) ,MAX([Week11]) ,MAX([Week12]) ,MAX([Week13]) ,MAX([Week14]) ,MAX([Week15]) ,MAX([Week16])FROM Random4;SET @Count = @Count + 1;END SELECT AVG(Week1) ,AVG(Week2) ,AVG([Week3]) ,AVG([Week4]) ,AVG([Week5]) ,AVG([Week6]) ,AVG([Week7]) ,AVG([Week8]) ,AVG([Week9]) ,AVG([Week10]) ,AVG([Week11]) ,AVG([Week12]) ,AVG([Week13]) ,AVG([Week14]) ,AVG([Week15]) ,AVG([Week16])FROM ##1D;SELECT AVG(Week1) ,AVG(Week2) ,AVG([Week3]) ,AVG([Week4]) ,AVG([Week5]) ,AVG([Week6]) ,AVG([Week7]) ,AVG([Week8]) ,AVG([Week9]) ,AVG([Week10]) ,AVG([Week11]) ,AVG([Week12]) ,AVG([Week13]) ,AVG([Week14]) ,AVG([Week15]) ,AVG([Week16])FROM ##2D;SELECT AVG(Week1) ,AVG(Week2) ,AVG([Week3]) ,AVG([Week4]) ,AVG([Week5]) ,AVG([Week6]) ,AVG([Week7]) ,AVG([Week8]) ,AVG([Week9]) ,AVG([Week10]) ,AVG([Week11]) ,AVG([Week12]) ,AVG([Week13]) ,AVG([Week14]) ,AVG([Week15]) ,AVG([Week16])FROM ##3D;SELECT AVG(Week1) ,AVG(Week2) ,AVG([Week3]) ,AVG([Week4]) ,AVG([Week5]) ,AVG([Week6]) ,AVG([Week7]) ,AVG([Week8]) ,AVG([Week9]) ,AVG([Week10]) ,AVG([Week11]) ,AVG([Week12]) ,AVG([Week13]) ,AVG([Week14]) ,AVG([Week15]) ,AVG([Week16])FROM ##4D;DROP TABLE ##1D;DROP TABLE ##2D;DROP TABLE ##3D;DROP TABLE ##4D;