Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE mlb_juiced_balls;
- INSERT INTO MLB_Teams(Team_Name, Team_ID) VALUES
- ('Arizona Diamondbacks', 'ARI'),
- ('Atlanta Braves', 'ATL'),
- ('Baltimore Orioles', 'BAL'),
- ('Boston Red Sox', 'BOS'),
- ('Chicago Cubs', 'CHI'),
- ('Chicago White Sox', 'CHW'),
- ('Cincinnati Reds', 'CIN'),
- ('Cleveland Indians', 'CLE'),
- ('Colorado Rockies', 'COL'),
- ('Detroit Tigers', 'DET'),
- ('Houston Astros', 'HOU'),
- ('Kansas City Royals', 'KCR'),
- ('Los Angeles Angels', 'LAA'),
- ('Los Angeles Dodgers', 'LAD'),
- ('Miami Marlins', 'MIA'),
- ('Milwaukee Brewers', 'MIL'),
- ('Minnesota Twins', 'MIN'),
- ('New York Mets', 'NYM'),
- ('New York Yankees', 'NYY'),
- ('Oakland Athletics', 'OAK'),
- ('Philadelphia Phillies', 'PHI'),
- ('Pittsburgh Pirates', 'PIT'),
- ('San Diego Padres', 'SDP'),
- ('San Francisco Giants', 'SFG'),
- ('Seattle Mariners', 'SEA'),
- ('St. Louis Cardinals', 'STL'),
- ('Tampa Bay Rays', 'TBR'),
- ('Texas Rangers', 'TEX'),
- ('Toronto Blue Jays', 'TOR'),
- ('Washington Nationals', 'WSN');
- INSERT INTO season_2019 (Team_ID, runs_per_game19, at_bats19, runs19, hits19, d0uble19, triple19, home_runs19, runs_batted_in19, bases_on_balls19, batting_avg19, on_base_percentage19, slugging_percentage19, total_bases19) VALUES
- ('ARI', '5.02', '5633', '813', '1419', '288', '40', '220', '778', '540', '0.252', '0.323', '0.434', '2447'),
- ('ATL', '5.28', '5560', '855', '1432', '277', '29', '249', '824', '619', '0.258', '0.336', '0.452', '2514'),
- ('BAL', '4.5', '5596', '729', '1379', '252', '25', '213', '698', '462', '0.246', '0.31', '0.415', '2320'),
- ('BOS', '5.56', '5770', '901', '1554', '345', '27', '245', '857', '590', '0.269', '0.34', '0.466', '2688'),
- ('CHC', '5.02', '5461', '814', '1378', '270', '26', '256', '783', '581', '0.252', '0.331', '0.452', '2468'),
- ('CHW', '4.4', '5529', '708', '1443', '260', '20', '182', '676', '378', '0.261', '0.314', '0.414', '2289'),
- ('CIN', '4.33', '5450', '701', '1328', '235', '27', '227', '679', '492', '0.244', '0.315', '0.422', '2298'),
- ('CLE', '4.75', '5425', '769', '1354', '286', '18', '223', '731', '563', '0.25', '0.323', '0.432', '2345'),
- ('COL', '5.15', '5660', '835', '1502', '323', '41', '224', '803', '489', '0.265', '0.326', '0.456', '2579'),
- ('DET', '3.61', '5549', '582', '1333', '292', '41', '149', '556', '391', '0.24', '0.294', '0.388', '2154'),
- ('HOU', '5.68', '5613', '920', '1538', '323', '28', '288', '891', '645', '0.274', '0.352', '0.495', '2781'),
- ('KCR', '4.27', '5496', '691', '1356', '281', '40', '162', '655', '456', '0.247', '0.309', '0.401', '2203'),
- ('LAA', '4.75', '5542', '769', '1368', '268', '21', '220', '734', '586', '0.247', '0.324', '0.422', '2338'),
- ('LAD', '5.47', '5493', '886', '1414', '302', '20', '279', '861', '607', '0.257', '0.338', '0.472', '2593'),
- ('MIA', '3.8', '5512', '615', '1326', '265', '18', '146', '593', '395', '0.241', '0.298', '0.375', '2065'),
- ('MIL', '4.75', '5542', '769', '1366', '279', '17', '250', '744', '629', '0.246', '0.329', '0.438', '2429'),
- ('MIN', '5.8', '5732', '939', '1547', '318', '23', '307', '906', '525', '0.27', '0.338', '0.494', '2832'),
- ('NYM', '4.88', '5624', '791', '1445', '280', '17', '242', '767', '516', '0.257', '0.328', '0.442', '2485'),
- ('NYY', '5.82', '5583', '943', '1493', '290', '17', '306', '904', '569', '0.267', '0.339', '0.49', '2735'),
- ('OAK', '5.22', '5561', '845', '1384', '292', '23', '257', '800', '578', '0.249', '0.327', '0.448', '2493'),
- ('PHI', '4.78', '5571', '774', '1369', '311', '26', '215', '742', '562', '0.246', '0.319', '0.427', '2377'),
- ('PIT', '4.68', '5657', '758', '1497', '315', '38', '163', '722', '425', '0.265', '0.321', '0.42', '2377'),
- ('SDP', '4.21', '5391', '682', '1281', '224', '24', '219', '652', '504', '0.238', '0.308', '0.41', '2210'),
- ('SEA', '4.68', '5500', '758', '1305', '254', '28', '239', '730', '588', '0.237', '0.316', '0.424', '2332'),
- ('SFG', '4.19', '5579', '678', '1332', '300', '26', '167', '655', '475', '0.239', '0.302', '0.392', '2185'),
- ('STL', '4.72', '5449', '764', '1336', '246', '24', '210', '714', '561', '0.245', '0.322', '0.415', '2260'),
- ('TBR', '4.75', '5628', '769', '1427', '291', '29', '217', '730', '542', '0.254', '0.325', '0.431', '2427'),
- ('TEX', '5', '5540', '810', '1374', '296', '24', '223', '765', '534', '0.248', '0.319', '0.431', '2387'),
- ('TOR', '4.48', '5493', '726', '1299', '270', '21', '247', '697', '509', '0.236', '0.305', '0.428', '2352'),
- ('WSN', '5.39', '5512', '873', '1460', '298', '27', '231', '824', '584', '0.265', '0.342', '0.454', '2505');
- INSERT INTO season_2018 (Team_ID, runs_per_game18, at_bats18, runs18, hits18, d0uble18, triple18, home_runs18, runs_batted_in18, bases_on_balls18, batting_avg18, on_base_percentage18, slugging_percentage18, total_bases18) VALUES
- ('ARI', '4.28', '5460', '693', '1283', '259', '50', '176', '658', '560', '0.235', '0.31', '0.397', '2170'),
- ('ATL', '4.69', '5582', '759', '1433', '314', '29', '175', '717', '511', '0.257', '0.324', '0.417', '2330'),
- ('BAL', '3.84', '5507', '622', '1317', '242', '15', '188', '593', '422', '0.239', '0.298', '0.391', '2153'),
- ('BOS', '5.41', '5623', '876', '1509', '355', '31', '208', '829', '569', '0.268', '0.339', '0.453', '2550'),
- ('CHC', '4.67', '5624', '761', '1453', '286', '34', '167', '722', '576', '0.258', '0.333', '0.41', '2308'),
- ('CHW', '4.05', '5523', '656', '1332', '259', '40', '182', '639', '425', '0.241', '0.302', '0.401', '2217'),
- ('CIN', '4.3', '5532', '696', '1404', '251', '25', '172', '665', '559', '0.254', '0.328', '0.401', '2221'),
- ('CLE', '5.05', '5595', '818', '1447', '297', '19', '216', '786', '554', '0.259', '0.332', '0.434', '2430'),
- ('COL', '4.79', '5541', '780', '1418', '280', '42', '210', '748', '507', '0.256', '0.322', '0.435', '2412'),
- ('DET', '3.89', '5494', '630', '1326', '284', '35', '135', '597', '428', '0.241', '0.3', '0.38', '2085'),
- ('HOU', '4.92', '5453', '797', '1390', '278', '18', '205', '763', '565', '0.255', '0.329', '0.425', '2319'),
- ('KCR', '3.94', '5505', '638', '1350', '283', '29', '155', '606', '427', '0.245', '0.305', '0.392', '2156'),
- ('LAA', '4.45', '5472', '721', '1323', '249', '23', '214', '690', '514', '0.242', '0.313', '0.413', '2260'),
- ('LAD', '4.93', '5572', '804', '1394', '296', '33', '235', '756', '647', '0.25', '0.333', '0.442', '2461'),
- ('MIA', '3.66', '5488', '589', '1303', '222', '24', '128', '554', '455', '0.237', '0.303', '0.357', '1957'),
- ('MIL', '4.63', '5542', '754', '1398', '252', '24', '218', '711', '537', '0.252', '0.323', '0.424', '2352'),
- ('MIN', '4.56', '5526', '738', '1379', '317', '22', '166', '704', '534', '0.25', '0.318', '0.405', '2238'),
- ('NYM', '4.17', '5468', '676', '1282', '265', '34', '170', '649', '566', '0.234', '0.312', '0.389', '2125'),
- ('NYY', '5.25', '5515', '851', '1374', '269', '23', '267', '821', '625', '0.249', '0.329', '0.451', '2490'),
- ('OAK', '5.02', '5579', '813', '1407', '322', '20', '227', '778', '550', '0.252', '0.325', '0.439', '2450'),
- ('PHI', '4.18', '5424', '677', '1270', '241', '30', '186', '653', '582', '0.234', '0.314', '0.393', '2129'),
- ('PIT', '4.3', '5447', '692', '1381', '290', '38', '157', '665', '474', '0.254', '0.317', '0.407', '2218'),
- ('SDP', '3.81', '5486', '617', '1289', '250', '30', '162', '583', '471', '0.235', '0.297', '0.38', '2085'),
- ('SEA', '4.18', '5513', '677', '1402', '256', '32', '176', '644', '430', '0.254', '0.314', '0.408', '2250'),
- ('SFG', '3.72', '5541', '603', '1324', '255', '30', '133', '573', '448', '0.239', '0.3', '0.368', '2038'),
- ('STL', '4.69', '5498', '759', '1369', '248', '9', '205', '725', '525', '0.249', '0.321', '0.409', '2250'),
- ('TBR', '4.42', '5475', '716', '1415', '274', '43', '150', '664', '540', '0.258', '0.333', '0.406', '2225'),
- ('TEX', '4.55', '5453', '737', '1308', '266', '24', '194', '696', '555', '0.24', '0.318', '0.404', '2204'),
- ('TOR', '4.38', '5477', '709', '1336', '320', '16', '217', '680', '499', '0.244', '0.312', '0.427', '2339'),
- ('WSN', '4.76', '5517', '771', '1402', '284', '25', '191', '737', '631', '0.254', '0.335', '0.419', '2309');
- INSERT INTO season_2017 (Team_ID, runs_per_game17, at_bats17, runs17, hits17, d0uble17, triple17, home_runs17, runs_batted_in17, bases_on_balls17, batting_avg17, on_base_percentage17, slugging_percentage17, total_bases17) VALUES
- ('ARI', '5.01', '5525', '812', '1405', '314', '39', '220', '776', '578', '0.254', '0.329', '0.445', '2457'),
- ('ATL', '4.52', '5584', '732', '1467', '289', '26', '165', '706', '474', '0.263', '0.326', '0.412', '2303'),
- ('BAL', '4.59', '5650', '743', '1469', '269', '12', '232', '713', '392', '0.26', '0.312', '0.435', '2458'),
- ('BOS', '4.85', '5669', '785', '1461', '302', '19', '168', '735', '571', '0.258', '0.329', '0.407', '2305'),
- ('CHC', '5.07', '5496', '822', '1402', '274', '29', '223', '785', '622', '0.255', '0.338', '0.437', '2403'),
- ('CHW', '4.36', '5513', '706', '1412', '256', '37', '186', '670', '401', '0.256', '0.314', '0.417', '2300'),
- ('CIN', '4.65', '5484', '753', '1390', '249', '38', '219', '715', '565', '0.253', '0.329', '0.433', '2372'),
- ('CLE', '5.05', '5511', '818', '1449', '333', '29', '212', '780', '604', '0.263', '0.339', '0.449', '2476'),
- ('COL', '5.09', '5534', '824', '1510', '293', '38', '192', '793', '519', '0.273', '0.338', '0.444', '2455'),
- ('DET', '4.54', '5556', '735', '1435', '289', '35', '187', '699', '503', '0.258', '0.324', '0.424', '2355'),
- ('HOU', '5.53', '5611', '896', '1581', '346', '20', '238', '854', '509', '0.282', '0.346', '0.478', '2681'),
- ('KCR', '4.33', '5536', '702', '1436', '260', '24', '193', '660', '390', '0.259', '0.311', '0.42', '2323'),
- ('LAA', '4.38', '5415', '710', '1314', '251', '14', '186', '678', '523', '0.243', '0.315', '0.397', '2151'),
- ('LAD', '4.75', '5408', '770', '1347', '312', '20', '221', '730', '649', '0.249', '0.334', '0.437', '2362'),
- ('MIA', '4.8', '5602', '778', '1497', '271', '31', '194', '743', '486', '0.267', '0.331', '0.431', '2412'),
- ('MIL', '4.52', '5467', '732', '1363', '267', '22', '224', '695', '547', '0.249', '0.322', '0.429', '2346'),
- ('MIN', '5.03', '5557', '815', '1444', '286', '31', '206', '781', '593', '0.26', '0.334', '0.434', '2410'),
- ('NYM', '4.54', '5510', '735', '1379', '286', '28', '224', '713', '529', '0.25', '0.32', '0.434', '2393'),
- ('NYY', '5.3', '5594', '858', '1463', '266', '23', '241', '821', '616', '0.262', '0.339', '0.447', '2498'),
- ('OAK', '4.56', '5464', '739', '1344', '305', '15', '234', '708', '565', '0.246', '0.319', '0.436', '2381'),
- ('PHI', '4.26', '5535', '690', '1382', '287', '36', '174', '654', '494', '0.25', '0.315', '0.409', '2263'),
- ('PIT', '4.12', '5458', '668', '1331', '249', '36', '151', '635', '519', '0.244', '0.318', '0.386', '2105'),
- ('SDP', '3.73', '5356', '604', '1251', '227', '31', '189', '576', '460', '0.234', '0.299', '0.393', '2107'),
- ('SEA', '4.63', '5551', '750', '1436', '281', '17', '200', '714', '487', '0.259', '0.325', '0.424', '2351'),
- ('SFG', '3.94', '5551', '639', '1382', '290', '28', '128', '612', '467', '0.249', '0.309', '0.38', '2112'),
- ('STL', '4.7', '5470', '761', '1402', '284', '28', '196', '728', '593', '0.256', '0.334', '0.426', '2330'),
- ('TBR', '4.28', '5478', '694', '1340', '226', '32', '228', '671', '545', '0.245', '0.317', '0.422', '2314'),
- ('TEX', '4.93', '5430', '799', '1326', '255', '21', '237', '756', '544', '0.244', '0.32', '0.43', '2334'),
- ('TOR', '4.28', '5499', '693', '1320', '269', '5', '222', '661', '542', '0.24', '0.312', '0.412', '2265'),
- ('WSN', '5.06', '5553', '819', '1477', '311', '31', '215', '796', '542', '0.266', '0.332', '0.449', '2495');
- INSERT INTO season_2016 (Team_ID, runs_per_game16, at_bats16, runs16, hits16, d0uble16, triple16, home_runs16, runs_batted_in16, bases_on_balls16, batting_avg16, on_base_percentage16, slugging_percentage16, total_bases16) VALUES
- ('ARI', '4.64', '5665', '752', '1479', '285', '56', '190', '709', '463', '0.261', '0.32', '0.432', '2446'),
- ('ATL', '4.03', '5514', '649', '1404', '295', '27', '122', '615', '502', '0.255', '0.321', '0.384', '2119'),
- ('BAL', '4.59', '5524', '744', '1413', '265', '6', '253', '710', '468', '0.256', '0.317', '0.443', '2449'),
- ('BOS', '5.42', '5670', '878', '1598', '343', '25', '208', '836', '558', '0.282', '0.348', '0.461', '2615'),
- ('CHC', '4.99', '5503', '808', '1409', '293', '30', '199', '767', '656', '0.256', '0.343', '0.429', '2359'),
- ('CHW', '4.23', '5550', '686', '1428', '277', '33', '168', '656', '455', '0.257', '0.317', '0.41', '2275'),
- ('CIN', '4.42', '5487', '716', '1403', '277', '33', '164', '678', '452', '0.256', '0.316', '0.408', '2238'),
- ('CLE', '4.83', '5484', '777', '1435', '308', '29', '185', '733', '531', '0.262', '0.329', '0.43', '2356'),
- ('COL', '5.22', '5614', '845', '1544', '318', '47', '204', '805', '494', '0.275', '0.336', '0.457', '2568'),
- ('DET', '4.66', '5526', '750', '1476', '252', '30', '211', '719', '493', '0.267', '0.331', '0.438', '2421'),
- ('HOU', '4.47', '5545', '724', '1367', '291', '29', '198', '689', '554', '0.247', '0.319', '0.417', '2310'),
- ('KCR', '4.17', '5552', '675', '1450', '264', '33', '147', '640', '382', '0.261', '0.312', '0.4', '2221'),
- ('LAA', '4.43', '5431', '717', '1410', '279', '20', '156', '686', '471', '0.26', '0.322', '0.405', '2197'),
- ('LAD', '4.48', '5518', '725', '1376', '272', '21', '189', '680', '525', '0.249', '0.319', '0.409', '2257'),
- ('MIA', '4.07', '5547', '655', '1460', '259', '42', '128', '626', '447', '0.263', '0.322', '0.394', '2187'),
- ('MIL', '4.14', '5330', '671', '1299', '249', '19', '194', '641', '599', '0.244', '0.322', '0.407', '2168'),
- ('MIN', '4.46', '5618', '722', '1409', '288', '35', '200', '690', '513', '0.251', '0.316', '0.421', '2367'),
- ('NYM', '4.14', '5459', '671', '1342', '240', '19', '218', '649', '517', '0.246', '0.316', '0.417', '2274'),
- ('NYY', '4.2', '5458', '680', '1378', '245', '20', '183', '647', '475', '0.252', '0.315', '0.405', '2212'),
- ('OAK', '4.03', '5500', '653', '1352', '270', '21', '169', '634', '442', '0.246', '0.304', '0.395', '2171'),
- ('PHI', '3.77', '5434', '610', '1305', '231', '35', '161', '574', '424', '0.24', '0.301', '0.384', '2089'),
- ('PIT', '4.5', '5542', '729', '1426', '277', '32', '153', '696', '561', '0.257', '0.332', '0.402', '2226'),
- ('SDP', '4.23', '5419', '686', '1275', '257', '26', '177', '654', '449', '0.235', '0.299', '0.39', '2115'),
- ('SEA', '4.74', '5583', '768', '1446', '251', '17', '223', '735', '506', '0.259', '0.326', '0.43', '2400'),
- ('SFG', '4.41', '5565', '715', '1437', '280', '54', '130', '675', '572', '0.258', '0.329', '0.398', '2215'),
- ('STL', '4.81', '5548', '779', '1415', '299', '32', '225', '745', '526', '0.255', '0.325', '0.442', '2453'),
- ('TBR', '4.15', '5481', '672', '1333', '288', '32', '216', '647', '449', '0.243', '0.307', '0.426', '2333'),
- ('TEX', '4.72', '5525', '765', '1446', '257', '23', '215', '746', '436', '0.262', '0.322', '0.433', '2394'),
- ('TOR', '4.69', '5479', '759', '1358', '276', '18', '221', '728', '632', '0.248', '0.33', '0.426', '2333'),
- ('WSN', '4.71', '5490', '763', '1403', '268', '29', '203', '735', '536', '0.256', '0.326', '0.426', '2338');
- INSERT INTO season_2015 (Team_ID, runs_per_game15, at_bats15, runs15, hits15, d0uble15, triple15, home_runs15, runs_batted_in15, bases_on_balls15, batting_avg15, on_base_percentage15, slugging_percentage15, total_bases15) VALUES
- ('ARI', '4.44', '5649', '720', '1494', '289', '48', '154', '680', '490', '0.264', '0.324', '0.414', '2341'),
- ('ATL', '3.54', '5420', '573', '1361', '251', '18', '100', '548', '471', '0.251', '0.314', '0.359', '1948'),
- ('BAL', '4.4', '5485', '713', '1370', '246', '20', '217', '686', '418', '0.25', '0.307', '0.421', '2307'),
- ('BOS', '4.62', '5640', '748', '1495', '294', '33', '161', '706', '478', '0.265', '0.325', '0.415', '2338'),
- ('CHC', '4.25', '5491', '689', '1341', '272', '30', '171', '657', '567', '0.244', '0.321', '0.398', '2186'),
- ('CHW', '3.84', '5533', '622', '1381', '260', '27', '136', '595', '404', '0.25', '0.306', '0.38', '2103'),
- ('CIN', '3.95', '5571', '640', '1382', '257', '27', '167', '613', '496', '0.248', '0.312', '0.394', '2194'),
- ('CLE', '4.16', '5439', '669', '1395', '303', '29', '141', '640', '533', '0.256', '0.325', '0.401', '2179'),
- ('COL', '4.55', '5572', '737', '1479', '274', '49', '186', '702', '388', '0.265', '0.315', '0.432', '2409'),
- ('DET', '4.28', '5605', '689', '1515', '289', '49', '151', '660', '455', '0.27', '0.328', '0.42', '2355'),
- ('HOU', '4.5', '5459', '729', '1363', '278', '26', '230', '691', '486', '0.25', '0.315', '0.437', '2383'),
- ('KCR', '4.47', '5575', '724', '1497', '300', '42', '139', '689', '383', '0.269', '0.322', '0.412', '2298'),
- ('LAA', '4.08', '5417', '661', '1331', '243', '21', '176', '621', '435', '0.246', '0.307', '0.396', '2144'),
- ('LAD', '4.12', '5385', '667', '1346', '263', '26', '187', '638', '563', '0.25', '0.326', '0.413', '2222'),
- ('MIA', '3.78', '5463', '613', '1420', '236', '40', '120', '575', '375', '0.26', '0.31', '0.384', '2096'),
- ('MIL', '4.04', '5480', '655', '1378', '274', '34', '145', '624', '412', '0.251', '0.307', '0.393', '2155'),
- ('MIN', '4.3', '5467', '696', '1349', '277', '44', '156', '661', '439', '0.247', '0.305', '0.399', '2182'),
- ('NYM', '4.22', '5527', '683', '1351', '295', '17', '177', '654', '488', '0.244', '0.312', '0.4', '2211'),
- ('NYY', '4.72', '5567', '764', '1397', '272', '19', '212', '737', '554', '0.251', '0.323', '0.421', '2343'),
- ('OAK', '4.28', '5600', '694', '1405', '277', '46', '146', '661', '475', '0.251', '0.312', '0.395', '2212'),
- ('PHI', '3.86', '5529', '626', '1374', '272', '37', '130', '586', '387', '0.249', '0.303', '0.382', '2110'),
- ('PIT', '4.3', '5631', '697', '1462', '292', '27', '140', '661', '461', '0.26', '0.323', '0.396', '2228'),
- ('SDP', '4.01', '5457', '650', '1324', '260', '36', '148', '623', '426', '0.243', '0.3', '0.385', '2100'),
- ('SEA', '4.05', '5544', '656', '1379', '262', '22', '198', '624', '478', '0.249', '0.311', '0.411', '2279'),
- ('SFG', '4.3', '5565', '696', '1486', '288', '39', '136', '663', '457', '0.267', '0.326', '0.406', '2260'),
- ('STL', '3.99', '5484', '647', '1386', '288', '39', '137', '619', '506', '0.253', '0.321', '0.394', '2163'),
- ('TBR', '3.98', '5485', '644', '1383', '278', '32', '167', '612', '436', '0.252', '0.314', '0.406', '2226'),
- ('TEX', '4.64', '5511', '751', '1419', '279', '32', '172', '707', '503', '0.257', '0.325', '0.413', '2278'),
- ('TOR', '5.5', '5509', '891', '1480', '308', '17', '232', '852', '570', '0.269', '0.34', '0.457', '2518'),
- ('WSN', '4.34', '5428', '703', '1363', '265', '13', '177', '665', '539', '0.251', '0.321', '0.403', '2185');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement