CREATE TABLE TEAM
		(
		T_NAME VARCHAR (20) UNIQUE,
		T_RATING INTEGER,
		PRIMARY KEY (T_NAME)
		);

CREATE TABLE MANAGER
		(
		M_NAME VARCHAR (20),
		T_NAME VARCHAR (20) REFERENCES TEAM
							ON UPDATE CASCADE
							ON DELETE SET NULL,
		PRIMARY KEY (M_NAME)
		);

CREATE TABLE ASSISTANT
		(
		A_NAME VARCHAR (20),
		M_NAME VARCHAR (20) REFERENCES MANAGER
							ON UPDATE CASCADE
							ON DELETE CASCADE,
		T_NAME VARCHAR (20) REFERENCES TEAM
							ON UPDATE CASCADE
							ON DELETE SET NULL,
		PRIMARY KEY (A_NAME)
		);

CREATE TABLE CATCHER
		(
		C_NO INTEGER,
		C_NAME VARCHAR (20),
		BATTING_AVG FLOAT,
		C_RATING INTEGER,
		T_NAME VARCHAR (20) REFERENCES TEAM
							ON UPDATE CASCADE
							ON DELETE SET NULL,
		PRIMARY KEY (C_NO, C_NAME)
		);

CREATE TABLE INFIELDER
		(
		I_NO INTEGER,
		I_NAME VARCHAR (20),
		BATTING_AVG FLOAT,
		I_RATING INTEGER,
		T_NAME VARCHAR (20) REFERENCES TEAM
							ON UPDATE CASCADE
							ON DELETE SET NULL,
		PRIMARY KEY (I_NO, I_NAME)
		);

CREATE TABLE OUTFIELDER
		(
		O_NO INTEGER,
		O_NAME VARCHAR (20),
		BATTING_AVG FLOAT,
		O_RATING INTEGER,
		T_NAME VARCHAR (20) REFERENCES TEAM
							ON UPDATE CASCADE
							ON DELETE SET NULL,
		PRIMARY KEY (O_NO, O_NAME)
		);

CREATE TABLE PITCHER
		(
		P_NO INTEGER,
		P_NAME VARCHAR (20),
		ERA FLOAT,
		P_RATING INTEGER,
		T_NAME VARCHAR (20) REFERENCES TEAM
							ON UPDATE CASCADE
							ON DELETE SET NULL,
		PRIMARY KEY (P_NO, P_NAME)
		);
		
CREATE TABLE GAME
		(
		T_NAME1 VARCHAR (20),
		T_NAME2 VARCHAR (20),
		WINNER VARCHAR (20),
		PRIMARY KEY (T_NAME1, T_NAME2)
		);

INSERT INTO TEAM VALUES ( 'Orioles', 58);
INSERT INTO TEAM VALUES ( 'Red Sox', 58);
INSERT INTO TEAM VALUES ( 'Yankees', 53);
INSERT INTO TEAM VALUES ( 'Devil Rays', 50);
INSERT INTO TEAM VALUES ( 'Blue Jays', 43);
INSERT INTO TEAM VALUES ( 'Tigers', 63);
INSERT INTO TEAM VALUES ( 'White Sox', 50);
INSERT INTO TEAM VALUES ( 'Indians', 48);
INSERT INTO TEAM VALUES ( 'Royals', 43);
INSERT INTO TEAM VALUES ( 'Twins', 37);

INSERT INTO MANAGER VALUES ( 'Torre', 'Yankees');
INSERT INTO MANAGER VALUES ( 'Williams', 'Red Sox');
INSERT INTO MANAGER VALUES ( 'Hargrove', 'Orioles');
INSERT INTO MANAGER VALUES ( 'Fregosi', 'Blue Jays');
INSERT INTO MANAGER VALUES ( 'Rothschild', 'Devil Rays');
INSERT INTO MANAGER VALUES ( 'Manuel', 'White Sox');
INSERT INTO MANAGER VALUES ( 'Nunez', 'Indians');
INSERT INTO MANAGER VALUES ( 'Garner', 'Tigers');
INSERT INTO MANAGER VALUES ( 'Kelly', 'Twins');
INSERT INTO MANAGER VALUES ( 'Muser', 'Royals');

INSERT INTO ASSISTANT VALUES ( 'Chambliss', 'Torre', 'Yankees');
INSERT INTO ASSISTANT VALUES ( 'Stottlemyre', 'Torre', 'Yankees');
INSERT INTO ASSISTANT VALUES ( 'Rice', 'Williams', 'Red Sox');
INSERT INTO ASSISTANT VALUES ( 'Kerrigan', 'Williams', 'Red Sox');
INSERT INTO ASSISTANT VALUES ( 'Crowley', 'Hargrove', 'Orioles');
INSERT INTO ASSISTANT VALUES ( 'Wiley', 'Hargrove', 'Orioles');
INSERT INTO ASSISTANT VALUES ( 'Gaston', 'Fregosi', 'Blue Jays');
INSERT INTO ASSISTANT VALUES ( 'Langford', 'Fregosi', 'Blue Jays');
INSERT INTO ASSISTANT VALUES ( 'Roberts', 'Rothschild', 'Devil Rays');
INSERT INTO ASSISTANT VALUES ( 'Williams', 'Rothschild', 'Devil Rays');
INSERT INTO ASSISTANT VALUES ( 'Joshua', 'Manuel', 'White Sox');
INSERT INTO ASSISTANT VALUES ( 'Contreras', 'Manuel', 'White Sox');
INSERT INTO ASSISTANT VALUES ( 'Jones', 'Manuel', 'Indians');
INSERT INTO ASSISTANT VALUES ( 'Pole', 'Manuel', 'Indians');
INSERT INTO ASSISTANT VALUES ( 'Madlock', 'Garner', 'Tigers');
INSERT INTO ASSISTANT VALUES ( 'Warthen', 'Garner', 'Tigers');
INSERT INTO ASSISTANT VALUES ( 'Ullger', 'Kelly', 'Twins');
INSERT INTO ASSISTANT VALUES ( 'Such', 'Kelly', 'Twins');
INSERT INTO ASSISTANT VALUES ( 'Johnson', 'Muser', 'Royals');
INSERT INTO ASSISTANT VALUES ( 'Strom', 'Muser', 'Royals');

INSERT INTO CATCHER VALUES ( 20, 'Posada', .204, 78, 'Yankees');
INSERT INTO CATCHER VALUES ( 10, 'Hatteberg', .265, 82, 'Red Sox');
INSERT INTO CATCHER VALUES ( 26, 'Fordyce', .232, 43, 'Orioles');
INSERT INTO CATCHER VALUES ( 30, 'Castillo', .276, 46, 'Blue Jays');
INSERT INTO CATCHER VALUES ( 8, 'DiFelice', .302, 67, 'Devil Rays');
INSERT INTO CATCHER VALUES ( 8, 'Johnson', .176, 86, 'White Sox');
INSERT INTO CATCHER VALUES ( 15, 'Alomar Jr', .315, 84, 'Indians');
INSERT INTO CATCHER VALUES ( 53, 'Cardona', .267, 62, 'Tigers');
INSERT INTO CATCHER VALUES ( 39, 'Moeller', .287, 56, 'Twins');
INSERT INTO CATCHER VALUES ( 22, 'Ortiz', .298, 75, 'Royals');

INSERT INTO INFIELDER VALUES ( 18, 'Brosius', .229, 76, 'Yankees');
INSERT INTO INFIELDER VALUES ( 2, 'Jeter', .317, 54, 'Yankees');
INSERT INTO INFIELDER VALUES ( 11, 'Knoblauch', .238, 86, 'Yankees');
INSERT INTO INFIELDER VALUES ( 24, 'Martinez', .364, 97, 'Yankees');
INSERT INTO INFIELDER VALUES ( 14, 'Sojo', .239, 75, 'Yankees');
INSERT INTO INFIELDER VALUES ( 13, 'Vizcaino', .316, 68, 'Yankees');
INSERT INTO INFIELDER VALUES ( 29, 'Alexander', .211, 86, 'Red Sox');
INSERT INTO INFIELDER VALUES ( 11, 'Brogna', .196, 67, 'Red Sox');
INSERT INTO INFIELDER VALUES ( 23, 'Daubach', .248, 92, 'Red Sox');
INSERT INTO INFIELDER VALUES ( 5, 'Garciaparra', .372, 86, 'Red Sox');
INSERT INTO INFIELDER VALUES ( 3, 'Lansing', .194, 65, 'Red Sox');
INSERT INTO INFIELDER VALUES ( 30, 'Offerman', .255, 58, 'Red Sox');
INSERT INTO INFIELDER VALUES ( 13, 'Coffie', .199, 67, 'Orioles');
INSERT INTO INFIELDER VALUES ( 18, 'Conine', .180, 59, 'Orioles');
INSERT INTO INFIELDER VALUES ( 11, 'DeShields', .256, 68, 'Orioles');
INSERT INTO INFIELDER VALUES ( 1, 'Garcia', .271, 86, 'Orioles');
INSERT INTO INFIELDER VALUES ( 10, 'Lewis', .234, 56, 'Orioles');
INSERT INTO INFIELDER VALUES ( 8, 'Ripken', .219, 68, 'Orioles');
INSERT INTO INFIELDER VALUES ( 7, 'Batista', .189, 56, 'Blue Jays');
INSERT INTO INFIELDER VALUES ( 18, 'Bush', .225, 86, 'Blue Jays');
INSERT INTO INFIELDER VALUES ( 25, 'Delgado', .257, 78, 'Blue Jays');
INSERT INTO INFIELDER VALUES ( 8, 'Gonzalez', .222, 86, 'Blue Jays');
INSERT INTO INFIELDER VALUES ( 4, 'Grebeck', .287, 46, 'Blue Jays');
INSERT INTO INFIELDER VALUES ( 31, 'Woodward', .274, 68, 'Blue Jays');
INSERT INTO INFIELDER VALUES ( 66, 'Brewer', .298, 86, 'Devil Rays');
INSERT INTO INFIELDER VALUES ( 1, 'Cairo', .312, 86, 'Devil Rays');
INSERT INTO INFIELDER VALUES ( 9, 'Castilla', .276, 56, 'Devil Rays');
INSERT INTO INFIELDER VALUES ( 13, 'Guillen', .248, 68, 'Devil Rays');
INSERT INTO INFIELDER VALUES ( 21, 'Huff', .215, 86, 'Devil Rays');
INSERT INTO INFIELDER VALUES ( 10, 'Johnson', .278, 65, 'Devil Rays');
INSERT INTO INFIELDER VALUES ( 17, 'Caruso', .283, 84, 'White Sox');
INSERT INTO INFIELDER VALUES ( 24, 'Crede', .275, 63, 'White Sox');
INSERT INTO INFIELDER VALUES ( 5, 'Durham', .237, 65, 'White Sox');
INSERT INTO INFIELDER VALUES ( 47, 'Graffanino', .245, 45, 'White Sox');
INSERT INTO INFIELDER VALUES ( 14, 'Konerko', .176, 81, 'White Sox');
INSERT INTO INFIELDER VALUES ( 31, 'Norton', .270, 71, 'White Sox');
INSERT INTO INFIELDER VALUES ( 12, 'Alomar', .319, 91, 'Indians');
INSERT INTO INFIELDER VALUES ( 17, 'Fryman', .245, 74, 'Indians');
INSERT INTO INFIELDER VALUES ( 8, 'McDonald', .234, 71, 'Indians');
INSERT INTO INFIELDER VALUES ( 23, 'Segui', .265, 76, 'Indians');
INSERT INTO INFIELDER VALUES ( 25, 'Thome', .320, 93, 'Indians');
INSERT INTO INFIELDER VALUES ( 13, 'Vizquel', .299, 93, 'Indians');
INSERT INTO INFIELDER VALUES ( 22, 'Allen', .234, 73, 'Tigers');
INSERT INTO INFIELDER VALUES ( 44, 'Clark', .269, 75, 'Tigers');
INSERT INTO INFIELDER VALUES ( 8, 'Cruz', .231, 77, 'Tigers');
INSERT INTO INFIELDER VALUES ( 9, 'Easley', .178, 72, 'Tigers');
INSERT INTO INFIELDER VALUES ( 18, 'Fick', .201, 67, 'Tigers');
INSERT INTO INFIELDER VALUES ( 7, 'Palmer', .271, 75, 'Tigers');
INSERT INTO INFIELDER VALUES ( 38, 'Blake', .219, 67, 'Twins');
INSERT INTO INFIELDER VALUES ( 1, 'Canizaro', .253, 83, 'Twins');
INSERT INTO INFIELDER VALUES ( 8, 'Coomer', .247, 56, 'Twins');
INSERT INTO INFIELDER VALUES ( 15, 'Guzman', .233, 65, 'Twins');
INSERT INTO INFIELDER VALUES ( 7, 'Hocking', .255, 83, 'Twins');
INSERT INTO INFIELDER VALUES ( 47, 'Koskie', .289, 82, 'Twins');
INSERT INTO INFIELDER VALUES ( 19, 'Delgado', .277, 45, 'Royals');
INSERT INTO INFIELDER VALUES ( 3, 'Febles', .234, 43, 'Royals');
INSERT INTO INFIELDER VALUES ( 6, 'McCarty', .256, 25, 'Royals');
INSERT INTO INFIELDER VALUES ( 1, 'Sanchez', .281, 64, 'Royals');
INSERT INTO INFIELDER VALUES ( 8, 'Ordaz', .218, 43, 'Royals');
INSERT INTO INFIELDER VALUES ( 16, 'Randa', .189, 63, 'Royals');

INSERT INTO OUTFIELDER VALUES ( 35, 'Bellinger', .127, 23, 'Yankees');
INSERT INTO OUTFIELDER VALUES ( 33, 'Canseco', .286, 54, 'Yankees');
INSERT INTO OUTFIELDER VALUES ( 28, 'Justice', .301, 73, 'Yankees');
INSERT INTO OUTFIELDER VALUES ( 21, 'oNeill', .294, 94, 'Yankees');
INSERT INTO OUTFIELDER VALUES ( 19, 'Polonia', .298, 77, 'Yankees');
INSERT INTO OUTFIELDER VALUES ( 51, 'Williams', .275, 86, 'Yankees');
INSERT INTO OUTFIELDER VALUES ( 56, 'Alcantara', .189, 74, 'Red Sox');
INSERT INTO OUTFIELDER VALUES ( 19, 'Bichette', .234, 57, 'Red Sox');
INSERT INTO OUTFIELDER VALUES ( 54, 'Burkhart', .299, 75, 'Red Sox');
INSERT INTO OUTFIELDER VALUES ( 99, 'Coleman', .233, 75, 'Red Sox');
INSERT INTO OUTFIELDER VALUES ( 18, 'Cummings', .217, 86, 'Red Sox');
INSERT INTO OUTFIELDER VALUES ( 2, 'Everett', .313, 86, 'Red Sox');
INSERT INTO OUTFIELDER VALUES ( 9, 'Anderson', .301, 63, 'Orioles');
INSERT INTO OUTFIELDER VALUES ( 88, 'Belle', .274, 65, 'Orioles');
INSERT INTO OUTFIELDER VALUES ( 57, 'Garcia', .291, 54, 'Orioles');
INSERT INTO OUTFIELDER VALUES ( 23, 'Hubbard', .222, 75, 'Orioles');
INSERT INTO OUTFIELDER VALUES ( 40, 'Kingsale', .211, 67, 'Orioles');
INSERT INTO OUTFIELDER VALUES ( 32, 'Matos', .255, 84, 'Orioles');
INSERT INTO OUTFIELDER VALUES ( 15, 'Cordova', .276, 64, 'Blue Jays');
INSERT INTO OUTFIELDER VALUES ( 23, 'Cruz', .287, 65, 'Blue Jays');
INSERT INTO OUTFIELDER VALUES ( 20, 'Fullmer', .298, 65, 'Blue Jays');
INSERT INTO OUTFIELDER VALUES ( 27, 'Greene', .258, 86, 'Blue Jays');
INSERT INTO OUTFIELDER VALUES ( 14, 'Martinez', .237, 65, 'Blue Jays');
INSERT INTO OUTFIELDER VALUES ( 43, 'Mondesi', .233, 56, 'Blue Jays');
INSERT INTO OUTFIELDER VALUES ( 28, 'Cox', .286, 67, 'Devil Rays');
INSERT INTO OUTFIELDER VALUES ( 30, 'Guillen', .245, 67, 'Devil Rays');
INSERT INTO OUTFIELDER VALUES ( 15, 'Kelly', .251, 85, 'Devil Rays');
INSERT INTO OUTFIELDER VALUES ( 44, 'Timmons', .211, 54, 'Devil Rays');
INSERT INTO OUTFIELDER VALUES ( 14, 'Tyner', .267, 85, 'Devil Rays');
INSERT INTO OUTFIELDER VALUES ( 23, 'Vaughn', .312, 67, 'Devil Rays');
INSERT INTO OUTFIELDER VALUES ( 25, 'Abbot', .305, 85, 'White Sox');
INSERT INTO OUTFIELDER VALUES ( 3, 'Baines', .230, 65, 'White Sox');
INSERT INTO OUTFIELDER VALUES ( 26, 'Christensen', .211, 56, 'White Sox');
INSERT INTO OUTFIELDER VALUES ( 45, 'Lee', .207, 85, 'White Sox');
INSERT INTO OUTFIELDER VALUES ( 30, 'Ordonez', .286, 64, 'White Sox');
INSERT INTO OUTFIELDER VALUES ( 35, 'Thomas', .318, 73, 'White Sox');
INSERT INTO OUTFIELDER VALUES ( 33, 'Branyan', .300, 72, 'Indians');
INSERT INTO OUTFIELDER VALUES ( 7, 'Lofton', .294, 88, 'Indians');
INSERT INTO OUTFIELDER VALUES ( 61, 'Perry', .205, 86, 'Indians');
INSERT INTO OUTFIELDER VALUES ( 24, 'Ramirez', .299, 89, 'Indians');
INSERT INTO OUTFIELDER VALUES ( 10, 'Roberts', .235, 85, 'Indians');
INSERT INTO OUTFIELDER VALUES ( 51, 'Cruz', .234, 57, 'Indians');
INSERT INTO OUTFIELDER VALUES ( 24, 'Becker', .298, 75, 'Tigers');
INSERT INTO OUTFIELDER VALUES ( 34, 'Encarnacion', .211, 44, 'Tigers');
INSERT INTO OUTFIELDER VALUES ( 19, 'Gonzalez', .209, 65, 'Tigers');
INSERT INTO OUTFIELDER VALUES ( 4, 'Higginson', .293, 65, 'Tigers');
INSERT INTO OUTFIELDER VALUES ( 29, 'Magee', .201, 47, 'Tigers');
INSERT INTO OUTFIELDER VALUES ( 43, 'McMillon', .219, 87, 'Tigers');
INSERT INTO OUTFIELDER VALUES ( 40, 'Barnes', .123, 84, 'Twins');
INSERT INTO OUTFIELDER VALUES ( 30, 'Buchanan', .216, 46, 'Twins');
INSERT INTO OUTFIELDER VALUES ( 48, 'Hunter', .176, 63, 'Twins');
INSERT INTO OUTFIELDER VALUES ( 11, 'Jones', .136, 63, 'Twins');
INSERT INTO OUTFIELDER VALUES ( 50, 'Lawton', .187,73 , 'Twins');
INSERT INTO OUTFIELDER VALUES ( 27, 'Ortiz', .304, 75, 'Twins');
INSERT INTO OUTFIELDER VALUES ( 15, 'Beltran', .207, 84, 'Royals');
INSERT INTO OUTFIELDER VALUES ( 18, 'Damon', .244, 85, 'Royals');
INSERT INTO OUTFIELDER VALUES ( 7, 'Dunwoody', .210, 57, 'Royals');
INSERT INTO OUTFIELDER VALUES ( 24, 'Dye', .215, 85, 'Royals');
INSERT INTO OUTFIELDER VALUES ( 14, 'Quinn', .257, 75, 'Royals');

INSERT INTO PITCHER VALUES ( 22, 'Clemens', 3.21, 56, 'Yankees');
INSERT INTO PITCHER VALUES ( 36, 'Cone', 0.00, 74, 'Yankees');
INSERT INTO PITCHER VALUES ( 17, 'Gooden', 9.00, 88, 'Yankees');
INSERT INTO PITCHER VALUES ( 26, 'Hernandez', 3.94, 79, 'Yankees');
INSERT INTO PITCHER VALUES ( 12, 'Neagle', 4.3, 87, 'Yankees');
INSERT INTO PITCHER VALUES ( 46, 'Pettitte', 2.84, 68, 'Yankees');
INSERT INTO PITCHER VALUES ( 46, 'Arrojo', 3.54, 77, 'Red Sox');
INSERT INTO PITCHER VALUES ( 47, 'Beck', 2.76, 73, 'Red Sox');
INSERT INTO PITCHER VALUES ( 37, 'Cormier', 3.76, 66, 'Red Sox');
INSERT INTO PITCHER VALUES ( 63, 'Crawford', 5.34, 78, 'Red Sox');
INSERT INTO PITCHER VALUES ( 55, 'Croushore', 3.54, 88, 'Red Sox');
INSERT INTO PITCHER VALUES ( 45, 'Martinez', 2.34, 97, 'Red Sox');
INSERT INTO PITCHER VALUES ( 45, 'Brea', 6.23, 76, 'Orioles');
INSERT INTO PITCHER VALUES ( 19, 'Erickson', 4.56, 69, 'Orioles');
INSERT INTO PITCHER VALUES ( 27, 'Groom', 5.34, 56, 'Orioles');
INSERT INTO PITCHER VALUES ( 41, 'Johnson', 6.77, 67, 'Orioles');
INSERT INTO PITCHER VALUES ( 75, 'Mills', 3.44, 76, 'Orioles');
INSERT INTO PITCHER VALUES ( 29, 'Spurgeon', 6.11, 67, 'Orioles');
INSERT INTO PITCHER VALUES ( 51, 'Borbon', 1.89, 87, 'Blue Jays');
INSERT INTO PITCHER VALUES ( 26, 'Carpenter', 3.49, 67, 'Blue Jays');
INSERT INTO PITCHER VALUES ( 37, 'Castillo', 3.65, 71, 'Blue Jays');
INSERT INTO PITCHER VALUES ( 40, 'DeWitt', 7.34, 73, 'Blue Jays');
INSERT INTO PITCHER VALUES ( 47, 'Escobar', 2.33, 78, 'Blue Jays');
INSERT INTO PITCHER VALUES ( 50, 'Hamilton', 6.44, 54, 'Blue Jays');
INSERT INTO PITCHER VALUES ( 40, 'Alvarez', 5.23, 57, 'Devil Rays');
INSERT INTO PITCHER VALUES ( 38, 'Creek', 2.45, 84, 'Devil Rays');
INSERT INTO PITCHER VALUES ( 48, 'Eiland', 5.32, 73, 'Devil Rays');
INSERT INTO PITCHER VALUES ( 45, 'Enders', 5.34, 44, 'Devil Rays');
INSERT INTO PITCHER VALUES ( 0, 'Fiore', 2.54, 86, 'Devil Rays');
INSERT INTO PITCHER VALUES ( 57, 'Guzman', 5.67, 68, 'Devil Rays');
INSERT INTO PITCHER VALUES ( 37, 'Baldwin', 4.12, 65, 'White Sox');
INSERT INTO PITCHER VALUES ( 44, 'Bradford', 1.21, 73, 'White Sox');
INSERT INTO PITCHER VALUES ( 50, 'Lowe', 1.23, 76, 'White Sox');
INSERT INTO PITCHER VALUES ( 40, 'Parque', 4.65, 86, 'White Sox');
INSERT INTO PITCHER VALUES ( 41, 'Simas', 7.45, 74, 'White Sox');
INSERT INTO PITCHER VALUES ( 32, 'Wells', 4.23, 67, 'White Sox');
INSERT INTO PITCHER VALUES ( 46, 'Bere', 1.11, 75, 'Indians');
INSERT INTO PITCHER VALUES ( 50, 'Brower', 1.21, 65, 'Indians');
INSERT INTO PITCHER VALUES ( 49, 'Brown', 5.45, 56, 'Indians');
INSERT INTO PITCHER VALUES ( 34, 'Burba', 7.89, 87, 'Indians');
INSERT INTO PITCHER VALUES ( 31, 'Finley', 2.45, 65, 'Indians');
INSERT INTO PITCHER VALUES ( 41, 'Nagy', 2.01, 89, 'Indians');
INSERT INTO PITCHER VALUES ( 14, 'Anderson', 7.34, 67, 'Tigers');
INSERT INTO PITCHER VALUES ( 49, 'Bernero', 6.34, 87, 'Tigers');
INSERT INTO PITCHER VALUES ( 20, 'Blair', 2.87, 67, 'Tigers');
INSERT INTO PITCHER VALUES ( 26, 'Brocail', 4.04, 57, 'Tigers');
INSERT INTO PITCHER VALUES ( 40, 'Cruz', 2.34, 85, 'Tigers');
INSERT INTO PITCHER VALUES ( 59, 'Jones', 4.06, 75, 'Tigers');
INSERT INTO PITCHER VALUES ( 59, 'Cressend', 3.02, 63, 'Twins');
INSERT INTO PITCHER VALUES ( 18, 'Guardado', 3.29, 67, 'Twins');
INSERT INTO PITCHER VALUES ( 32, 'Hawkins', 6.23, 84, 'Twins');
INSERT INTO PITCHER VALUES ( 51, 'Kinney', 2.33, 65, 'Twins');
INSERT INTO PITCHER VALUES ( 19, 'Lincoln', 1.11, 65, 'Twins');
INSERT INTO PITCHER VALUES ( 46, 'Wells', 6.11, 55, 'Twins');
INSERT INTO PITCHER VALUES ( 52, 'Bottalico', 7.02, 56, 'Royals');
INSERT INTO PITCHER VALUES ( 49, 'Fussel', 6.20, 68, 'Royals');
INSERT INTO PITCHER VALUES ( 54, 'Larkin', 3.43, 57, 'Royals');
INSERT INTO PITCHER VALUES ( 59, 'Meadows', 6.43, 81, 'Royals');
INSERT INTO PITCHER VALUES ( 45, 'Moreno', 3.42, 83, 'Royals');
INSERT INTO PITCHER VALUES ( 57, 'Mullen', 2.01, 81, 'Royals');

INSERT INTO GAME VALUES ( 'Orioles', 'Tigers', 'Orioles');
INSERT INTO GAME VALUES ( 'Red Sox', 'White Sox', 'Red Sox');
INSERT INTO GAME VALUES ( 'Yankees', 'Indians', 'Indians');
INSERT INTO GAME VALUES ( 'Devil Rays', 'Royals', 'Royals');
INSERT INTO GAME VALUES ( 'Blue Jays', 'Twins', 'Twins');
INSERT INTO GAME VALUES ( 'Orioles', 'Twins', 'Twins');
INSERT INTO GAME VALUES ( 'Red Sox', 'Royals', 'Royals');
INSERT INTO GAME VALUES ( 'Yankees', 'Tigers', 'Yankees');
INSERT INTO GAME VALUES ( 'Devil Rays', 'White Sox', 'White Sox');
INSERT INTO GAME VALUES ( 'Blue Jays', 'Indians', 'Indians');

CREATE ASSERTION GOOD_PITCHER CHECK
	(SELECT * FROM PITCHER WHERE ERA < 5.00);