CREATE TABLE #s1(
[Student] [nvarchar](50) NOT NULL,
[subject] [nvarchar](50) NOT NULL,
[grade] [float] NULL
)
INSERT INTO #S1 VALUES ('Student 01','Math',97.19)
INSERT INTO #S1 VALUES ('Student 02','Math',94.07)
INSERT INTO #S1 VALUES ('Student 03','Math',92.78)
INSERT INTO #S1 VALUES ('Student 04','Math',91.86)
INSERT INTO #S1 VALUES ('Student 05','Math',91.12)
INSERT INTO #S1 VALUES ('Student 06','Math',90.48)
INSERT INTO #S1 VALUES ('Student 07','Math',89.9)
INSERT INTO #S1 VALUES ('Student 08','Math',89.36)
INSERT INTO #S1 VALUES ('Student 09','Math',88.86)
INSERT INTO #S1 VALUES ('Student 10','Math',88.37)
INSERT INTO #S1 VALUES ('Student 11','Math',87.89)
INSERT INTO #S1 VALUES ('Student 12','Math',87.42)
INSERT INTO #S1 VALUES ('Student 13','Math',86.95)
INSERT INTO #S1 VALUES ('Student 14','Math',86.47)
INSERT INTO #S1 VALUES ('Student 15','Math',85.98)
INSERT INTO #S1 VALUES ('Student 16','Math',85.46)
INSERT INTO #S1 VALUES ('Student 17','Math',84.92)
INSERT INTO #S1 VALUES ('Student 18','Math',84.32)
INSERT INTO #S1 VALUES ('Student 19','Math',83.65)
INSERT INTO #S1 VALUES ('Student 20','Math',82.86)
INSERT INTO #S1 VALUES ('Student 21','Math',81.85)
INSERT INTO #S1 VALUES ('Student 22','Math',80.32)
INSERT INTO #S1 VALUES ('Student 01','Science',97.64)
INSERT INTO #S1 VALUES ('Student 02','Science',95.02)
INSERT INTO #S1 VALUES ('Student 03','Science',93.94)
INSERT INTO #S1 VALUES ('Student 04','Science',93.17)
INSERT INTO #S1 VALUES ('Student 05','Science',92.54)
INSERT INTO #S1 VALUES ('Student 06','Science',92)
INSERT INTO #S1 VALUES ('Student 07','Science',91.51)
INSERT INTO #S1 VALUES ('Student 08','Science',91.06)
INSERT INTO #S1 VALUES ('Student 09','Science',90.64)
INSERT INTO #S1 VALUES ('Student 10','Science',90.23)
INSERT INTO #S1 VALUES ('Student 11','Science',89.83)
INSERT INTO #S1 VALUES ('Student 12','Science',89.43)
INSERT INTO #S1 VALUES ('Student 13','Science',89.04)
INSERT INTO #S1 VALUES ('Student 14','Science',88.64)
INSERT INTO #S1 VALUES ('Student 15','Science',88.22)
INSERT INTO #S1 VALUES ('Student 16','Science',87.79)
INSERT INTO #S1 VALUES ('Student 17','Science',87.33)
INSERT INTO #S1 VALUES ('Student 18','Science',86.83)
INSERT INTO #S1 VALUES ('Student 19','Science',86.26)
INSERT INTO #S1 VALUES ('Student 20','Science',85.6)
INSERT INTO #S1 VALUES ('Student 21','Science',84.75)
INSERT INTO #S1 VALUES ('Student 22','Science',83.47)
INSERT INTO #S1 VALUES ('Student 01','Foreign Language',96.52)
INSERT INTO #S1 VALUES ('Student 02','Foreign Language',92.64)
INSERT INTO #S1 VALUES ('Student 03','Foreign Language',91.05)
INSERT INTO #S1 VALUES ('Student 04','Foreign Language',89.91)
INSERT INTO #S1 VALUES ('Student 05','Foreign Language',88.99)
INSERT INTO #S1 VALUES ('Student 06','Foreign Language',88.19)
INSERT INTO #S1 VALUES ('Student 07','Foreign Language',87.47)
INSERT INTO #S1 VALUES ('Student 08','Foreign Language',86.81)
INSERT INTO #S1 VALUES ('Student 09','Foreign Language',86.18)
INSERT INTO #S1 VALUES ('Student 10','Foreign Language',85.58)
INSERT INTO #S1 VALUES ('Student 11','Foreign Language',84.99)
INSERT INTO #S1 VALUES ('Student 12','Foreign Language',84.4)
INSERT INTO #S1 VALUES ('Student 13','Foreign Language',83.82)
INSERT INTO #S1 VALUES ('Student 14','Foreign Language',83.22)
INSERT INTO #S1 VALUES ('Student 15','Foreign Language',82.61)
INSERT INTO #S1 VALUES ('Student 16','Foreign Language',81.97)
INSERT INTO #S1 VALUES ('Student 17','Foreign Language',81.29)
INSERT INTO #S1 VALUES ('Student 18','Foreign Language',80.55)
INSERT INTO #S1 VALUES ('Student 19','Foreign Language',79.72)
INSERT INTO #S1 VALUES ('Student 20','Foreign Language',78.74)
INSERT INTO #S1 VALUES ('Student 21','Foreign Language',77.49)
INSERT INTO #S1 VALUES ('Student 22','Foreign Language',75.6)
INSERT INTO #S1 VALUES ('Student 01','History',98.09)
INSERT INTO #S1 VALUES ('Student 02','History',95.97)
INSERT INTO #S1 VALUES ('Student 03','History',95.09)
INSERT INTO #S1 VALUES ('Student 04','History',94.47)
INSERT INTO #S1 VALUES ('Student 05','History',93.96)
INSERT INTO #S1 VALUES ('Student 06','History',93.52)
INSERT INTO #S1 VALUES ('Student 07','History',93.13)
INSERT INTO #S1 VALUES ('Student 08','History',92.77)
INSERT INTO #S1 VALUES ('Student 09','History',92.42)
INSERT INTO #S1 VALUES ('Student 10','History',92.09)
INSERT INTO #S1 VALUES ('Student 11','History',91.77)
INSERT INTO #S1 VALUES ('Student 12','History',91.45)
INSERT INTO #S1 VALUES ('Student 13','History',91.13)
INSERT INTO #S1 VALUES ('Student 14','History',90.8)
INSERT INTO #S1 VALUES ('Student 15','History',90.47)
INSERT INTO #S1 VALUES ('Student 16','History',90.12)
INSERT INTO #S1 VALUES ('Student 17','History',89.74)
INSERT INTO #S1 VALUES ('Student 18','History',89.34)
INSERT INTO #S1 VALUES ('Student 19','History',88.88)
INSERT INTO #S1 VALUES ('Student 20','History',88.34)
INSERT INTO #S1 VALUES ('Student 21','History',87.66)
INSERT INTO #S1 VALUES ('Student 22','History',86.62)
INSERT INTO #S1 VALUES ('Student 01','Literature',98.09)
INSERT INTO #S1 VALUES ('Student 02','Literature',95.97)
INSERT INTO #S1 VALUES ('Student 03','Literature',95.09)
INSERT INTO #S1 VALUES ('Student 04','Literature',94.47)
INSERT INTO #S1 VALUES ('Student 05','Literature',93.96)
INSERT INTO #S1 VALUES ('Student 06','Literature',93.52)
INSERT INTO #S1 VALUES ('Student 07','Literature',93.13)
INSERT INTO #S1 VALUES ('Student 08','Literature',92.77)
INSERT INTO #S1 VALUES ('Student 09','Literature',92.42)
INSERT INTO #S1 VALUES ('Student 10','Literature',92.09)
INSERT INTO #S1 VALUES ('Student 11','Literature',91.77)
INSERT INTO #S1 VALUES ('Student 12','Literature',91.45)
INSERT INTO #S1 VALUES ('Student 13','Literature',91.13)
INSERT INTO #S1 VALUES ('Student 14','Literature',90.8)
INSERT INTO #S1 VALUES ('Student 15','Literature',90.47)
INSERT INTO #S1 VALUES ('Student 16','Literature',90.12)
INSERT INTO #S1 VALUES ('Student 17','Literature',89.74)
INSERT INTO #S1 VALUES ('Student 18','Literature',89.34)
INSERT INTO #S1 VALUES ('Student 19','Literature',88.88)
INSERT INTO #S1 VALUES ('Student 20','Literature',88.34)
INSERT INTO #S1 VALUES ('Student 21','Literature',87.66)
INSERT INTO #S1 VALUES ('Student 22','Literature',86.62)
CREATE TABLE #s2(
[student] [nvarchar](50) NOT NULL,
[math] [float] NULL,
[science] [float] NULL,
[f_language] [float] NULL,
[history] [float] NULL,
[literature] [float] NULL
)
insert into #s2 values ('Student 01',97.19,97.64,96.52,98.09,98.09)
insert into #s2 values ('Student 02',94.07,95.02,92.64,95.97,95.97)
insert into #s2 values ('Student 03',92.78,93.94,91.05,95.09,95.09)
insert into #s2 values ('Student 04',91.86,93.17,89.91,94.47,94.47)
insert into #s2 values ('Student 05',91.12,92.54,88.99,93.96,93.96)
insert into #s2 values ('Student 06',90.48,92,88.19,93.52,93.52)
insert into #s2 values ('Student 07',89.9,91.51,87.47,93.13,93.13)
insert into #s2 values ('Student 08',89.36,91.06,86.81,92.77,92.77)
insert into #s2 values ('Student 09',88.86,90.64,86.18,92.42,92.42)
insert into #s2 values ('Student 10',88.37,90.23,85.58,92.09,92.09)
insert into #s2 values ('Student 11',87.89,89.83,84.99,91.77,91.77)
insert into #s2 values ('Student 12',87.42,89.43,84.4,91.45,91.45)
insert into #s2 values ('Student 13',86.95,89.04,83.82,91.13,91.13)
insert into #s2 values ('Student 14',86.47,88.64,83.22,90.8,90.8)
insert into #s2 values ('Student 15',85.98,88.22,82.61,90.47,90.47)
insert into #s2 values ('Student 16',85.46,87.79,81.97,90.12,90.12)
insert into #s2 values ('Student 17',84.92,87.33,81.29,89.74,89.74)
insert into #s2 values ('Student 18',84.32,86.83,80.55,89.34,89.34)
insert into #s2 values ('Student 19',83.65,86.26,79.72,88.88,88.88)
insert into #s2 values ('Student 20',82.86,85.6,78.74,88.34,88.34)
insert into #s2 values ('Student 21',81.85,84.75,77.49,87.66,87.66)
insert into #s2 values ('Student 22',80.32,83.47,75.6,86.62,86.62)
CREATE TABLE #f1(
[SYMBOL] [nvarchar](10) NOT NULL,
[FY] [float] NOT NULL,
[DESCR] [nvarchar](30) NOT NULL,
[AMOUNT] [float] NOT NULL,
)
INSERT INTO #f1 VALUES ('GOOG',2008,'Sales',21795.55)
INSERT INTO #f1 VALUES ('GOOG',2007,'Sales',16593.99)
INSERT INTO #f1 VALUES ('GOOG',2006,'Sales',10604.92)
INSERT INTO #f1 VALUES ('GOOG',2005,'Sales',6138.56)
INSERT INTO #f1 VALUES ('GOOG',2004,'Sales',3189.22)
INSERT INTO #f1 VALUES ('GOOG',2003,'Sales',1465.93)
INSERT INTO #f1 VALUES ('GOOG',2002,'Sales',439.51)
INSERT INTO #f1 VALUES ('GOOG',2001,'Sales',86.43)
INSERT INTO #f1 VALUES ('GOOG',2000,'Sales',19.11)
INSERT INTO #f1 VALUES ('GOOG',1999,'Sales',0.22)
INSERT INTO #f1 VALUES ('EBAY',2008,'Sales',8541.26)
INSERT INTO #f1 VALUES ('EBAY',2007,'Sales',7672.33)
INSERT INTO #f1 VALUES ('EBAY',2006,'Sales',5969.74)
INSERT INTO #f1 VALUES ('EBAY',2005,'Sales',4552.4)
INSERT INTO #f1 VALUES ('EBAY',2004,'Sales',3271.31)
INSERT INTO #f1 VALUES ('EBAY',2003,'Sales',2165.1)
INSERT INTO #f1 VALUES ('EBAY',2002,'Sales',1214.1)
INSERT INTO #f1 VALUES ('EBAY',2001,'Sales',748.82)
INSERT INTO #f1 VALUES ('EBAY',2000,'Sales',431.42)
INSERT INTO #f1 VALUES ('EBAY',1999,'Sales',224.72)
INSERT INTO #f1 VALUES ('AMZN',2008,'Sales',19166)
INSERT INTO #f1 VALUES ('AMZN',2007,'Sales',14835)
INSERT INTO #f1 VALUES ('AMZN',2006,'Sales',10711)
INSERT INTO #f1 VALUES ('AMZN',2005,'Sales',8490)
INSERT INTO #f1 VALUES ('AMZN',2004,'Sales',6921.12)
INSERT INTO #f1 VALUES ('AMZN',2003,'Sales',5263.7)
INSERT INTO #f1 VALUES ('AMZN',2002,'Sales',3932.94)
INSERT INTO #f1 VALUES ('AMZN',2001,'Sales',3122.43)
INSERT INTO #f1 VALUES ('AMZN',2000,'Sales',2761.98)
INSERT INTO #f1 VALUES ('AMZN',1999,'Sales',1639.84)
INSERT INTO #f1 VALUES ('CSCO',2008,'Sales',39540)
INSERT INTO #f1 VALUES ('CSCO',2007,'Sales',34922)
INSERT INTO #f1 VALUES ('CSCO',2006,'Sales',28484)
INSERT INTO #f1 VALUES ('CSCO',2005,'Sales',24801)
INSERT INTO #f1 VALUES ('CSCO',2004,'Sales',22045)
INSERT INTO #f1 VALUES ('CSCO',2003,'Sales',18878)
INSERT INTO #f1 VALUES ('CSCO',2002,'Sales',18915)
INSERT INTO #f1 VALUES ('CSCO',2001,'Sales',22293)
INSERT INTO #f1 VALUES ('CSCO',2000,'Sales',18928)
INSERT INTO #f1 VALUES ('CSCO',1999,'Sales',12173)
INSERT INTO #f1 VALUES ('MSFT',2008,'Sales',60420)
INSERT INTO #f1 VALUES ('MSFT',2007,'Sales',51122)
INSERT INTO #f1 VALUES ('MSFT',2006,'Sales',44282)
INSERT INTO #f1 VALUES ('MSFT',2005,'Sales',39788)
INSERT INTO #f1 VALUES ('MSFT',2004,'Sales',36835)
INSERT INTO #f1 VALUES ('MSFT',2003,'Sales',32187)
INSERT INTO #f1 VALUES ('MSFT',2002,'Sales',28365)
INSERT INTO #f1 VALUES ('MSFT',2001,'Sales',25296)
INSERT INTO #f1 VALUES ('MSFT',2000,'Sales',22956)
INSERT INTO #f1 VALUES ('MSFT',1999,'Sales',19747)
INSERT INTO #f1 VALUES ('GOOG',2008,'EBIT',5853.6)
INSERT INTO #f1 VALUES ('GOOG',2007,'EBIT',5673.98)
INSERT INTO #f1 VALUES ('GOOG',2006,'EBIT',4011.04)
INSERT INTO #f1 VALUES ('GOOG',2005,'EBIT',2141.68)
INSERT INTO #f1 VALUES ('GOOG',2004,'EBIT',650.23)
INSERT INTO #f1 VALUES ('GOOG',2003,'EBIT',346.65)
INSERT INTO #f1 VALUES ('GOOG',2002,'EBIT',184.92)
INSERT INTO #f1 VALUES ('GOOG',2001,'EBIT',10.07)
INSERT INTO #f1 VALUES ('GOOG',2000,'EBIT',-14.69)
INSERT INTO #f1 VALUES ('GOOG',1999,'EBIT',-6.08)
INSERT INTO #f1 VALUES ('EBAY',2008,'EBIT',2183.56)
INSERT INTO #f1 VALUES ('EBAY',2007,'EBIT',750.85)
INSERT INTO #f1 VALUES ('EBAY',2006,'EBIT',1547.06)
INSERT INTO #f1 VALUES ('EBAY',2005,'EBIT',1549.33)
INSERT INTO #f1 VALUES ('EBAY',2004,'EBIT',1128.23)
INSERT INTO #f1 VALUES ('EBAY',2003,'EBIT',661.5)
INSERT INTO #f1 VALUES ('EBAY',2002,'EBIT',398.13)
INSERT INTO #f1 VALUES ('EBAY',2001,'EBIT',162.94)
INSERT INTO #f1 VALUES ('EBAY',2000,'EBIT',77.96)
INSERT INTO #f1 VALUES ('EBAY',1999,'EBIT',18.14)
INSERT INTO #f1 VALUES ('AMZN',2008,'EBIT',901)
INSERT INTO #f1 VALUES ('AMZN',2007,'EBIT',660)
INSERT INTO #f1 VALUES ('AMZN',2006,'EBIT',377)
INSERT INTO #f1 VALUES ('AMZN',2005,'EBIT',428)
INSERT INTO #f1 VALUES ('AMZN',2004,'EBIT',355.87)
INSERT INTO #f1 VALUES ('AMZN',2003,'EBIT',38.99)
INSERT INTO #f1 VALUES ('AMZN',2002,'EBIT',-150.63)
INSERT INTO #f1 VALUES ('AMZN',2001,'EBIT',-526.43)
INSERT INTO #f1 VALUES ('AMZN',2000,'EBIT',-1106.68)
INSERT INTO #f1 VALUES ('AMZN',1999,'EBIT',-643.2)
INSERT INTO #f1 VALUES ('CSCO',2008,'EBIT',10255)
INSERT INTO #f1 VALUES ('CSCO',2007,'EBIT',9461)
INSERT INTO #f1 VALUES ('CSCO',2006,'EBIT',7633)
INSERT INTO #f1 VALUES ('CSCO',2005,'EBIT',8036)
INSERT INTO #f1 VALUES ('CSCO',2004,'EBIT',6992)
INSERT INTO #f1 VALUES ('CSCO',2003,'EBIT',5013)
INSERT INTO #f1 VALUES ('CSCO',2002,'EBIT',2710)
INSERT INTO #f1 VALUES ('CSCO',2001,'EBIT',-874)
INSERT INTO #f1 VALUES ('CSCO',2000,'EBIT',4343)
INSERT INTO #f1 VALUES ('CSCO',1999,'EBIT',3203)
INSERT INTO #f1 VALUES ('MSFT',2008,'EBIT',23814)
INSERT INTO #f1 VALUES ('MSFT',2007,'EBIT',20101)
INSERT INTO #f1 VALUES ('MSFT',2006,'EBIT',18262)
INSERT INTO #f1 VALUES ('MSFT',2005,'EBIT',16628)
INSERT INTO #f1 VALUES ('MSFT',2004,'EBIT',12196)
INSERT INTO #f1 VALUES ('MSFT',2003,'EBIT',11054)
INSERT INTO #f1 VALUES ('MSFT',2002,'EBIT',7875)
INSERT INTO #f1 VALUES ('MSFT',2001,'EBIT',11525)
INSERT INTO #f1 VALUES ('MSFT',2000,'EBIT',14275)
INSERT INTO #f1 VALUES ('MSFT',1999,'EBIT',11891)
INSERT INTO #f1 VALUES ('GOOG',2008,'Depreciation',1499.89)
INSERT INTO #f1 VALUES ('GOOG',2007,'Depreciation',967.66)
INSERT INTO #f1 VALUES ('GOOG',2006,'Depreciation',571.94)
INSERT INTO #f1 VALUES ('GOOG',2005,'Depreciation',293.81)
INSERT INTO #f1 VALUES ('GOOG',2004,'Depreciation',148.47)
INSERT INTO #f1 VALUES ('GOOG',2003,'Depreciation',50.19)
INSERT INTO #f1 VALUES ('GOOG',2002,'Depreciation',18.03)
INSERT INTO #f1 VALUES ('GOOG',2001,'Depreciation',10.03)
INSERT INTO #f1 VALUES ('GOOG',2000,'Depreciation',0)
INSERT INTO #f1 VALUES ('GOOG',1999,'Depreciation',0)
INSERT INTO #f1 VALUES ('EBAY',2008,'Depreciation',719.81)
INSERT INTO #f1 VALUES ('EBAY',2007,'Depreciation',576.61)
INSERT INTO #f1 VALUES ('EBAY',2006,'Depreciation',521.63)
INSERT INTO #f1 VALUES ('EBAY',2005,'Depreciation',369.54)
INSERT INTO #f1 VALUES ('EBAY',2004,'Depreciation',249.42)
INSERT INTO #f1 VALUES ('EBAY',2003,'Depreciation',156.46)
INSERT INTO #f1 VALUES ('EBAY',2002,'Depreciation',76.64)
INSERT INTO #f1 VALUES ('EBAY',2001,'Depreciation',78.39)
INSERT INTO #f1 VALUES ('EBAY',2000,'Depreciation',38.13)
INSERT INTO #f1 VALUES ('EBAY',1999,'Depreciation',19.75)
INSERT INTO #f1 VALUES ('AMZN',2008,'Depreciation',340)
INSERT INTO #f1 VALUES ('AMZN',2007,'Depreciation',271)
INSERT INTO #f1 VALUES ('AMZN',2006,'Depreciation',210)
INSERT INTO #f1 VALUES ('AMZN',2005,'Depreciation',118)
INSERT INTO #f1 VALUES ('AMZN',2004,'Depreciation',75.66)
INSERT INTO #f1 VALUES ('AMZN',2003,'Depreciation',72.74)
INSERT INTO #f1 VALUES ('AMZN',2002,'Depreciation',81.66)
INSERT INTO #f1 VALUES ('AMZN',2001,'Depreciation',264.03)
INSERT INTO #f1 VALUES ('AMZN',2000,'Depreciation',404.78)
INSERT INTO #f1 VALUES ('AMZN',1999,'Depreciation',251.5)
INSERT INTO #f1 VALUES ('CSCO',2008,'Depreciation',1977)
INSERT INTO #f1 VALUES ('CSCO',2007,'Depreciation',1569)
INSERT INTO #f1 VALUES ('CSCO',2006,'Depreciation',1353)
INSERT INTO #f1 VALUES ('CSCO',2005,'Depreciation',1020)
INSERT INTO #f1 VALUES ('CSCO',2004,'Depreciation',1199)
INSERT INTO #f1 VALUES ('CSCO',2003,'Depreciation',1463)
INSERT INTO #f1 VALUES ('CSCO',2002,'Depreciation',1957)
INSERT INTO #f1 VALUES ('CSCO',2001,'Depreciation',2236)
INSERT INTO #f1 VALUES ('CSCO',2000,'Depreciation',863)
INSERT INTO #f1 VALUES ('CSCO',1999,'Depreciation',489)
INSERT INTO #f1 VALUES ('MSFT',2008,'Depreciation',1872)
INSERT INTO #f1 VALUES ('MSFT',2007,'Depreciation',1406)
INSERT INTO #f1 VALUES ('MSFT',2006,'Depreciation',990)
INSERT INTO #f1 VALUES ('MSFT',2005,'Depreciation',884)
INSERT INTO #f1 VALUES ('MSFT',2004,'Depreciation',817)
INSERT INTO #f1 VALUES ('MSFT',2003,'Depreciation',1090)
INSERT INTO #f1 VALUES ('MSFT',2002,'Depreciation',1014)
INSERT INTO #f1 VALUES ('MSFT',2001,'Depreciation',1238)
INSERT INTO #f1 VALUES ('MSFT',2000,'Depreciation',900)
INSERT INTO #f1 VALUES ('MSFT',1999,'Depreciation',483)
INSERT INTO #f1 VALUES ('GOOG',2008,'Net Income',4226.86)
INSERT INTO #f1 VALUES ('GOOG',2007,'Net Income',4203.72)
INSERT INTO #f1 VALUES ('GOOG',2006,'Net Income',3077.45)
INSERT INTO #f1 VALUES ('GOOG',2005,'Net Income',1465.4)
INSERT INTO #f1 VALUES ('GOOG',2004,'Net Income',399.12)
INSERT INTO #f1 VALUES ('GOOG',2003,'Net Income',105.65)
INSERT INTO #f1 VALUES ('GOOG',2002,'Net Income',99.66)
INSERT INTO #f1 VALUES ('GOOG',2001,'Net Income',6.99)
INSERT INTO #f1 VALUES ('GOOG',2000,'Net Income',-14.69)
INSERT INTO #f1 VALUES ('GOOG',1999,'Net Income',-6.08)
INSERT INTO #f1 VALUES ('EBAY',2008,'Net Income',1779.47)
INSERT INTO #f1 VALUES ('EBAY',2007,'Net Income',348.25)
INSERT INTO #f1 VALUES ('EBAY',2006,'Net Income',1125.64)
INSERT INTO #f1 VALUES ('EBAY',2005,'Net Income',1082.04)
INSERT INTO #f1 VALUES ('EBAY',2004,'Net Income',778.22)
INSERT INTO #f1 VALUES ('EBAY',2003,'Net Income',447.18)
INSERT INTO #f1 VALUES ('EBAY',2002,'Net Income',249.89)
INSERT INTO #f1 VALUES ('EBAY',2001,'Net Income',90.45)
INSERT INTO #f1 VALUES ('EBAY',2000,'Net Income',48.29)
INSERT INTO #f1 VALUES ('EBAY',1999,'Net Income',9.57)
INSERT INTO #f1 VALUES ('AMZN',2008,'Net Income',645)
INSERT INTO #f1 VALUES ('AMZN',2007,'Net Income',476)
INSERT INTO #f1 VALUES ('AMZN',2006,'Net Income',190)
INSERT INTO #f1 VALUES ('AMZN',2005,'Net Income',333)
INSERT INTO #f1 VALUES ('AMZN',2004,'Net Income',588.45)
INSERT INTO #f1 VALUES ('AMZN',2003,'Net Income',35.28)
INSERT INTO #f1 VALUES ('AMZN',2002,'Net Income',-149.93)
INSERT INTO #f1 VALUES ('AMZN',2001,'Net Income',-556.75)
INSERT INTO #f1 VALUES ('AMZN',2000,'Net Income',-1411.27)
INSERT INTO #f1 VALUES ('AMZN',1999,'Net Income',-719.97)
INSERT INTO #f1 VALUES ('CSCO',2008,'Net Income',8052)
INSERT INTO #f1 VALUES ('CSCO',2007,'Net Income',7333)
INSERT INTO #f1 VALUES ('CSCO',2006,'Net Income',5580)
INSERT INTO #f1 VALUES ('CSCO',2005,'Net Income',5741)
INSERT INTO #f1 VALUES ('CSCO',2004,'Net Income',4968)
INSERT INTO #f1 VALUES ('CSCO',2003,'Net Income',3578)
INSERT INTO #f1 VALUES ('CSCO',2002,'Net Income',1893)
INSERT INTO #f1 VALUES ('CSCO',2001,'Net Income',-1014)
INSERT INTO #f1 VALUES ('CSCO',2000,'Net Income',2668)
INSERT INTO #f1 VALUES ('CSCO',1999,'Net Income',2023)
INSERT INTO #f1 VALUES ('MSFT',2008,'Net Income',17681)
INSERT INTO #f1 VALUES ('MSFT',2007,'Net Income',14065)
INSERT INTO #f1 VALUES ('MSFT',2006,'Net Income',12599)
INSERT INTO #f1 VALUES ('MSFT',2005,'Net Income',12254)
INSERT INTO #f1 VALUES ('MSFT',2004,'Net Income',8168)
INSERT INTO #f1 VALUES ('MSFT',2003,'Net Income',7531)
INSERT INTO #f1 VALUES ('MSFT',2002,'Net Income',5355)
INSERT INTO #f1 VALUES ('MSFT',2001,'Net Income',7721)
INSERT INTO #f1 VALUES ('MSFT',2000,'Net Income',9421)
INSERT INTO #f1 VALUES ('MSFT',1999,'Net Income',7785)
INSERT INTO #f1 VALUES ('GOOG',2008,'EPS',13.31)
INSERT INTO #f1 VALUES ('GOOG',2007,'EPS',13.29)
INSERT INTO #f1 VALUES ('GOOG',2006,'EPS',9.94)
INSERT INTO #f1 VALUES ('GOOG',2005,'EPS',5.02)
INSERT INTO #f1 VALUES ('GOOG',2004,'EPS',1.46)
INSERT INTO #f1 VALUES ('GOOG',2003,'EPS',0.41)
INSERT INTO #f1 VALUES ('GOOG',2002,'EPS',0.45)
INSERT INTO #f1 VALUES ('GOOG',2001,'EPS',0.04)
INSERT INTO #f1 VALUES ('GOOG',2000,'EPS',-0.22)
INSERT INTO #f1 VALUES ('GOOG',1999,'EPS',-0.14)
INSERT INTO #f1 VALUES ('EBAY',2008,'EPS',1.36)
INSERT INTO #f1 VALUES ('EBAY',2007,'EPS',0.25)
INSERT INTO #f1 VALUES ('EBAY',2006,'EPS',0.79)
INSERT INTO #f1 VALUES ('EBAY',2005,'EPS',0.78)
INSERT INTO #f1 VALUES ('EBAY',2004,'EPS',0.57)
INSERT INTO #f1 VALUES ('EBAY',2003,'EPS',0.34)
INSERT INTO #f1 VALUES ('EBAY',2002,'EPS',0.21)
INSERT INTO #f1 VALUES ('EBAY',2001,'EPS',0.08)
INSERT INTO #f1 VALUES ('EBAY',2000,'EPS',0.04)
INSERT INTO #f1 VALUES ('EBAY',1999,'EPS',0.01)
INSERT INTO #f1 VALUES ('AMZN',2008,'EPS',1.49)
INSERT INTO #f1 VALUES ('AMZN',2007,'EPS',1.12)
INSERT INTO #f1 VALUES ('AMZN',2006,'EPS',0.45)
INSERT INTO #f1 VALUES ('AMZN',2005,'EPS',0.78)
INSERT INTO #f1 VALUES ('AMZN',2004,'EPS',1.39)
INSERT INTO #f1 VALUES ('AMZN',2003,'EPS',0.08)
INSERT INTO #f1 VALUES ('AMZN',2002,'EPS',-0.4)
INSERT INTO #f1 VALUES ('AMZN',2001,'EPS',-1.53)
INSERT INTO #f1 VALUES ('AMZN',2000,'EPS',-4.02)
INSERT INTO #f1 VALUES ('AMZN',1999,'EPS',-2.2)
INSERT INTO #f1 VALUES ('CSCO',2008,'EPS',1.31)
INSERT INTO #f1 VALUES ('CSCO',2007,'EPS',1.17)
INSERT INTO #f1 VALUES ('CSCO',2006,'EPS',0.89)
INSERT INTO #f1 VALUES ('CSCO',2005,'EPS',0.87)
INSERT INTO #f1 VALUES ('CSCO',2004,'EPS',0.7)
INSERT INTO #f1 VALUES ('CSCO',2003,'EPS',0.5)
INSERT INTO #f1 VALUES ('CSCO',2002,'EPS',0.25)
INSERT INTO #f1 VALUES ('CSCO',2001,'EPS',-0.14)
INSERT INTO #f1 VALUES ('CSCO',2000,'EPS',0.36)
INSERT INTO #f1 VALUES ('CSCO',1999,'EPS',0.29)
INSERT INTO #f1 VALUES ('MSFT',2008,'EPS',1.87)
INSERT INTO #f1 VALUES ('MSFT',2007,'EPS',1.42)
INSERT INTO #f1 VALUES ('MSFT',2006,'EPS',1.2)
INSERT INTO #f1 VALUES ('MSFT',2005,'EPS',1.12)
INSERT INTO #f1 VALUES ('MSFT',2004,'EPS',0.75)
INSERT INTO #f1 VALUES ('MSFT',2003,'EPS',0.69)
INSERT INTO #f1 VALUES ('MSFT',2002,'EPS',0.48)
INSERT INTO #f1 VALUES ('MSFT',2001,'EPS',0.69)
INSERT INTO #f1 VALUES ('MSFT',2000,'EPS',0.85)
INSERT INTO #f1 VALUES ('MSFT',1999,'EPS',0.71)
INSERT INTO #f1 VALUES ('GOOG',2008,'Tax Rate',27.79)
INSERT INTO #f1 VALUES ('GOOG',2007,'Tax Rate',25.91)
INSERT INTO #f1 VALUES ('GOOG',2006,'Tax Rate',23.28)
INSERT INTO #f1 VALUES ('GOOG',2005,'Tax Rate',31.58)
INSERT INTO #f1 VALUES ('GOOG',2004,'Tax Rate',38.62)
INSERT INTO #f1 VALUES ('GOOG',2003,'Tax Rate',69.52)
INSERT INTO #f1 VALUES ('GOOG',2002,'Tax Rate',46.11)
INSERT INTO #f1 VALUES ('GOOG',2001,'Tax Rate',30.62)
INSERT INTO #f1 VALUES ('GOOG',2000,'Tax Rate',0)
INSERT INTO #f1 VALUES ('GOOG',1999,'Tax Rate',0)
INSERT INTO #f1 VALUES ('EBAY',2008,'Tax Rate',18.51)
INSERT INTO #f1 VALUES ('EBAY',2007,'Tax Rate',53.62)
INSERT INTO #f1 VALUES ('EBAY',2006,'Tax Rate',27.24)
INSERT INTO #f1 VALUES ('EBAY',2005,'Tax Rate',30.16)
INSERT INTO #f1 VALUES ('EBAY',2004,'Tax Rate',30.48)
INSERT INTO #f1 VALUES ('EBAY',2003,'Tax Rate',31.25)
INSERT INTO #f1 VALUES ('EBAY',2002,'Tax Rate',36.66)
INSERT INTO #f1 VALUES ('EBAY',2001,'Tax Rate',49.1)
INSERT INTO #f1 VALUES ('EBAY',2000,'Tax Rate',41.98)
INSERT INTO #f1 VALUES ('EBAY',1999,'Tax Rate',46.7)
INSERT INTO #f1 VALUES ('AMZN',2008,'Tax Rate',27.41)
INSERT INTO #f1 VALUES ('AMZN',2007,'Tax Rate',27.88)
INSERT INTO #f1 VALUES ('AMZN',2006,'Tax Rate',49.6)
INSERT INTO #f1 VALUES ('AMZN',2005,'Tax Rate',22.2)
INSERT INTO #f1 VALUES ('AMZN',2004,'Tax Rate',-65.36)
INSERT INTO #f1 VALUES ('AMZN',2003,'Tax Rate',9.51)
INSERT INTO #f1 VALUES ('AMZN',2002,'Tax Rate',0)
INSERT INTO #f1 VALUES ('AMZN',2001,'Tax Rate',0)
INSERT INTO #f1 VALUES ('AMZN',2000,'Tax Rate',0)
INSERT INTO #f1 VALUES ('AMZN',1999,'Tax Rate',0)
INSERT INTO #f1 VALUES ('CSCO',2008,'Tax Rate',21.48)
INSERT INTO #f1 VALUES ('CSCO',2007,'Tax Rate',22.49)
INSERT INTO #f1 VALUES ('CSCO',2006,'Tax Rate',26.9)
INSERT INTO #f1 VALUES ('CSCO',2005,'Tax Rate',28.56)
INSERT INTO #f1 VALUES ('CSCO',2004,'Tax Rate',28.95)
INSERT INTO #f1 VALUES ('CSCO',2003,'Tax Rate',28.63)
INSERT INTO #f1 VALUES ('CSCO',2002,'Tax Rate',30.15)
INSERT INTO #f1 VALUES ('CSCO',2001,'Tax Rate',0)
INSERT INTO #f1 VALUES ('CSCO',2000,'Tax Rate',38.57)
INSERT INTO #f1 VALUES ('CSCO',1999,'Tax Rate',36.84)
INSERT INTO #f1 VALUES ('MSFT',2008,'Tax Rate',25.75)
INSERT INTO #f1 VALUES ('MSFT',2007,'Tax Rate',30.03)
INSERT INTO #f1 VALUES ('MSFT',2006,'Tax Rate',31.01)
INSERT INTO #f1 VALUES ('MSFT',2005,'Tax Rate',26.31)
INSERT INTO #f1 VALUES ('MSFT',2004,'Tax Rate',33.03)
INSERT INTO #f1 VALUES ('MSFT',2003,'Tax Rate',31.87)
INSERT INTO #f1 VALUES ('MSFT',2002,'Tax Rate',32)
INSERT INTO #f1 VALUES ('MSFT',2001,'Tax Rate',33.01)
INSERT INTO #f1 VALUES ('MSFT',2000,'Tax Rate',34)
INSERT INTO #f1 VALUES ('MSFT',1999,'Tax Rate',34.53)
CREATE TABLE #f2(
[SYMBOL] [nchar](10) NOT NULL,
[FY] [float] NOT NULL,
[SALES] [float] NOT NULL,
[EBIT] [float] NOT NULL,
[DEPREC] [float] NOT NULL,
[NETINC] [float] NOT NULL,
[EPS] [float] NOT NULL,
[TAXRATE] [float] NOT NULL
)
INSERT INTO #f2 VALUES ('GOOG',2008,21795.55,5853.6,1499.89,4226.86,13.31,27.79)
INSERT INTO #f2 VALUES ('GOOG',2007,16593.99,5673.98,967.66,4203.72,13.29,25.91)
INSERT INTO #f2 VALUES ('GOOG',2006,10604.92,4011.04,571.94,3077.45,9.94,23.28)
INSERT INTO #f2 VALUES ('GOOG',2005,6138.56,2141.68,293.81,1465.4,5.02,31.58)
INSERT INTO #f2 VALUES ('GOOG',2004,3189.22,650.23,148.47,399.12,1.46,38.62)
INSERT INTO #f2 VALUES ('GOOG',2003,1465.93,346.65,50.19,105.65,0.41,69.52)
INSERT INTO #f2 VALUES ('GOOG',2002,439.51,184.92,18.03,99.66,0.45,46.11)
INSERT INTO #f2 VALUES ('GOOG',2001,86.43,10.07,10.03,6.99,0.04,30.62)
INSERT INTO #f2 VALUES ('GOOG',2000,19.11,-14.69,0,-14.69,-0.22,0)
INSERT INTO #f2 VALUES ('GOOG',1999,0.22,-6.08,0,-6.08,-0.14,0)
INSERT INTO #f2 VALUES ('EBAY',2008,8541.26,2183.56,719.81,1779.47,1.36,18.51)
INSERT INTO #f2 VALUES ('EBAY',2007,7672.33,750.85,576.61,348.25,0.25,53.62)
INSERT INTO #f2 VALUES ('EBAY',2006,5969.74,1547.06,521.63,1125.64,0.79,27.24)
INSERT INTO #f2 VALUES ('EBAY',2005,4552.4,1549.33,369.54,1082.04,0.78,30.16)
INSERT INTO #f2 VALUES ('EBAY',2004,3271.31,1128.23,249.42,778.22,0.57,30.48)
INSERT INTO #f2 VALUES ('EBAY',2003,2165.1,661.5,156.46,447.18,0.34,31.25)
INSERT INTO #f2 VALUES ('EBAY',2002,1214.1,398.13,76.64,249.89,0.21,36.66)
INSERT INTO #f2 VALUES ('EBAY',2001,748.82,162.94,78.39,90.45,0.08,49.1)
INSERT INTO #f2 VALUES ('EBAY',2000,431.42,77.96,38.13,48.29,0.04,41.98)
INSERT INTO #f2 VALUES ('EBAY',1999,224.72,18.14,19.75,9.57,0.01,46.7)
INSERT INTO #f2 VALUES ('AMZN',2008,19166,901,340,645,1.49,27.41)
INSERT INTO #f2 VALUES ('AMZN',2007,14835,660,271,476,1.12,27.88)
INSERT INTO #f2 VALUES ('AMZN',2006,10711,377,210,190,0.45,49.6)
INSERT INTO #f2 VALUES ('AMZN',2005,8490,428,118,333,0.78,22.2)
INSERT INTO #f2 VALUES ('AMZN',2004,6921.12,355.87,75.66,588.45,1.39,-65.36)
INSERT INTO #f2 VALUES ('AMZN',2003,5263.7,38.99,72.74,35.28,0.08,9.51)
INSERT INTO #f2 VALUES ('AMZN',2002,3932.94,-150.63,81.66,-149.93,-0.4,0)
INSERT INTO #f2 VALUES ('AMZN',2001,3122.43,-526.43,264.03,-556.75,-1.53,0)
INSERT INTO #f2 VALUES ('AMZN',2000,2761.98,-1106.68,404.78,-1411.27,-4.02,0)
INSERT INTO #f2 VALUES ('AMZN',1999,1639.84,-643.2,251.5,-719.97,-2.2,0)
INSERT INTO #f2 VALUES ('CSCO',2008,39540,10255,1977,8052,1.31,21.48)
INSERT INTO #f2 VALUES ('CSCO',2007,34922,9461,1569,7333,1.17,22.49)
INSERT INTO #f2 VALUES ('CSCO',2006,28484,7633,1353,5580,0.89,26.9)
INSERT INTO #f2 VALUES ('CSCO',2005,24801,8036,1020,5741,0.87,28.56)
INSERT INTO #f2 VALUES ('CSCO',2004,22045,6992,1199,4968,0.7,28.95)
INSERT INTO #f2 VALUES ('CSCO',2003,18878,5013,1463,3578,0.5,28.63)
INSERT INTO #f2 VALUES ('CSCO',2002,18915,2710,1957,1893,0.25,30.15)
INSERT INTO #f2 VALUES ('CSCO',2001,22293,-874,2236,-1014,-0.14,0)
INSERT INTO #f2 VALUES ('CSCO',2000,18928,4343,863,2668,0.36,38.57)
INSERT INTO #f2 VALUES ('CSCO',1999,12173,3203,489,2023,0.29,36.84)
INSERT INTO #f2 VALUES ('MSFT',2008,60420,23814,1872,17681,1.87,25.75)
INSERT INTO #f2 VALUES ('MSFT',2007,51122,20101,1406,14065,1.42,30.03)
INSERT INTO #f2 VALUES ('MSFT',2006,44282,18262,990,12599,1.2,31.01)
INSERT INTO #f2 VALUES ('MSFT',2005,39788,16628,884,12254,1.12,26.31)
INSERT INTO #f2 VALUES ('MSFT',2004,36835,12196,817,8168,0.75,33.03)
INSERT INTO #f2 VALUES ('MSFT',2003,32187,11054,1090,7531,0.69,31.87)
INSERT INTO #f2 VALUES ('MSFT',2002,28365,7875,1014,5355,0.48,32)
INSERT INTO #f2 VALUES ('MSFT',2001,25296,11525,1238,7721,0.69,33.01)
INSERT INTO #f2 VALUES ('MSFT',2000,22956,14275,900,9421,0.85,34)
INSERT INTO #f2 VALUES ('MSFT',1999,19747,11891,483,7785,0.71,34.53)