Baseball Tables

<PRE>

drop table baseball;

create table baseball (First_Name Varchar2(15), Last_Name Varchar2(20), BARank Number(3,0), Batting_Ave Number(6,3), HRRank Number(3,0), Home_Runs Number(3,0), RBIRank Number(3,0), RBIs Number(4,0), SARank Number(3,0), Slugging_Ave Number(6,3), HitRank Number(3,0), Hits Number(4,0), DOB Date, DOD Date);

insert into baseball values ('Ty','Cobb',1,0.366,111,118,6,1937,40,0.512,2,4189,'18-DEC-1886','17-JUL-1961');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values('Hank','Aaron',100,0.305 ,1,755,1,2297,12,0.555 ,3,3771,'05-FEB-1934');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values('Stan','Musial',26, 0.331 ,17,475,5,1951,9, 0.559 ,4,3630,'21-NOV-1920');

insert into baseball values ('Tris','Speaker',5, 0.345 ,112,117,1,1937,51, 0.500 ,5,3514,'04-APR-1888','08-DEC-1958');

insert into baseball values ('Cap','Anson',29, 0.329 ,115,97,3,2076,110, 0.446 ,7,3418,'11-APR-1852','14-APR-1922');

insert into baseball values ('Honus','Wagner',31, 0.327 ,114,101,16,1732,104, 0.466 ,8,3415,'24-FEB-1874','06-DEC-1955');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Willie','Mays',101, 0.302 ,3,660,8,1903,10, 0.557 ,10,3283,'06-MAY-1931');

insert into baseball values ('Nap','Lajoie',17, 0.338 ,116,82,21,1599,105, 0.466 ,11,3242,'05-SEP-1874','07-FEB-1959');

insert into baseball values ('Paul','Waner',22, 0.333 ,113,113,67,1309,102, 0.473 ,14,3152,'16-APR-1903','29-AUG-1965');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Paul','Molitor',95, 0.308 ,105,234,68,1307,109, 0.448 ,19,3014,'22-AUG-1956');

insert into baseball values ('Roberto','Clemente',52, 0.317 ,104,240,69,1305,100, 0.475 ,21,3000,'16-AUG-1934','31-DEC-1972');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Frank','Robinson',105, 0.294 ,4,586,15,1812,20, 0.537 ,24,2943,'31-AUG-1935');

insert into baseball values ('Rogers','Hornsby',2, 0.358 ,73,301,25,1584,8, 0.577 ,26,2930,'27-APR-1896','05-JAN-1963');

insert into baseball values ('Babe','Ruth',9, 0.342 ,2,714,2,2213,1, 0.690 ,32,2873,'06-FEB-1895','16-AUG-1948');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Brooks','Robinson',117, 0.267 ,94,268,55,1357,115, 0.401 ,34,2848,'18-MAY-1937');

insert into baseball values ('Luke','Appling',83, 0.310 ,118,45,102,1116,116, 0.398 ,39,2749,'02-APR-1907','03-JAN-1991');

insert into baseball values ('Goose','Goslin',59, 0.316 ,101,248,20,1609,53, 0.500 ,41,2735,'16-OCT-1900','15-MAY-1971');

insert into baseball values ('Lou','Gehrig',15, 0.340 ,16,493,4,1995,3, 0.632 ,43,2721,'19-JUN-1903','02-JUN-1941');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Ted','Williams',6, 0.344 ,11,521,12,1839,2, 0.634 ,56,2654,'30-AUG-1918');

insert into baseball values ('Jimmie','Foxx',34, 0.325 ,9,534,7,1922,4, 0.609 ,57,2646,'22-OCT-1907','21-JUL-1967');

insert into baseball values ('Rabbit','Maranville',122, 0.258 ,121,28,112,884,121, 0.340 ,60,2605,'11-NOV-1891','05-JAN-1954');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Ernie','Banks',111, 0.274 ,13,512,19,1636,55, 0.500 ,64,2583,'31-JAN-1931');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Cal','Ripken',109, 0.277 ,45,353,53,1369,108, 0.450 ,68,2549,'24-AUG-1960');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Reggie','Jackson',120, 0.262 ,6,563,17,1702,75, 0.490 ,63,2548,'18-MAY-1946');

insert into baseball values ('Lloyd','Waner',57, 0.316 ,122,27,115,598,117, 0.393 ,80,2459,'16-MAR-1906','22-JUL-1982');

insert into baseball values ('Pie','Traynor',46, 0.320 ,117,58,81,1273,113, 0.435 ,87,2416,'11-NOV-1899','16-MAR-1972');

insert into baseball values ('Stuffy','McInnis',99, 0.307 ,124,20,106,1060,118, 0.381 ,89,2405,'19-SEP-1890','16-FEB-1960');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Joe','Torre',103, 0.297 ,100,252,100,1185,107, 0.452 ,99,2342,'18-JUL-1940');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Eddie','Mathews',113, 0.271 ,12,512,40,1453,41, 0.509 ,100,2315,'13-OCT-1931');

insert into baseball values ('Kiki','Cuyler',43, 0.321 ,109,128,104,1065,101, 0.474 ,101,2299,'30-AUG-1898','11-FEB-1950');

insert into baseball values ('Joe','DiMaggio',36, 0.325 ,40,361,32,1537,7, 0.579 ,102,2214,'25-NOV-1914','08-MAR-1999');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Willie','McCovey',115, 0.270 ,10,521,29,1555,39, 0.515 ,103,2211,'10-JAN-1938');

insert into baseball values ('Pee Wee','Reese',116, 0.269 ,110,126,111,885,119, 0.377 ,104,2170,'23-JUL-1918','14-AUG-1999');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Don','Mattingly',99, 0.307 ,106,222,103,1099,103, 0.471 ,105,2153,'20-APR-1961');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Yogi','Berra',106, 0.285 ,42,358,43,1430,94, 0.482 ,106,2150,'12-MAY-1925');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Duke','Snider',104, 0.295 ,25,407,59,1333,19, 0.541 ,107,2116,'19-SEP-1926');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Mark','Grace',91, 0.311 ,108,133,110,898,111, 0.446 ,108,2016,'28-JUN-1964');

insert into baseball values ('Gil','Hodges',112, 0.273 ,38,370,80,1274,83, 0.487 ,109,1921,'04-APR-1924','02-APR-1972');

insert into baseball values ('Joe','Adcock',109, 0.277 ,53,336,101,1122,88, 0.485 ,110,1832,'30-OCT-1927','03-MAY-1999');

insert into baseball values ('Ted','Kluszewski',102, 0.298 ,85,279,107,1028,60, 0.498 ,111,1766,'10-SEP-1924','29-MAR-1988');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Bobby','Thomson',115, 0.270 ,99,264,108,1026,106, 0.462 ,112,1705,'25-OCT-1923');

insert into baseball values ('Hank','Greenberg',63, 0.313 ,56,331,78,1276,5, 0.605 ,113,1628,'01-JAN-1911','04-SEP-1986');

insert into baseball values ('Jackie','Robinson',75, 0.311 ,107,137,114,734,114, 0.409 ,114,1518,'31-JAN-1919','24-OCT-1972');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Mark','McGwire',119, 0.265 ,14,505,90,1244,6, 0.585 ,115,1464,'01-OCT-1963');

insert into baseball values ('Hack','Wilson',99, 0.307 ,102,244,105,1062,16, 0.545 ,116,1461,'26-APR-1900','23-NOV-1948');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Sammy','Sosa',118, 0.267 ,63,320,109,906,43, 0.507 ,117,1368,'12-NOV-1968');

insert into baseball values ('Roy','Campanella',110, 0.276 ,103,242,113,856,54, 0.500 ,118,1161,'19-NOV1921','26-JUN-1993');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Al','Spangler',121, 0.262 ,123,21,117,175,120, 0.351 ,119,594,'08-JUL-1933');

insert into baseball values ('Dutch','Zwilling',107, 0.284 ,120,30,116,202,112, 0.438 ,120,364,'02-NOV-1888','27-MAR-1978');

insert into baseball (First_Name, Last_Name, BARank, Batting_Ave, HRRank, Home_Runs, RBIRank, RBIs, SARank, Slugging_Ave, HitRank, Hits, DOB) values ('Warren','Spahn',123, 0.194 ,119,35,118,141,122, 0.287 ,121,363,'23-APR-1921');

</PRE>