MLB Standings

sql is SELECT t.league_id, l.league_name, t.division_id, d.division_name, t.team_name, r.wins, r.losses, r.wins/(r.losses +r.wins) AS PCT, r.games_behind as "GB", r.home_wins, r.home_losses, r.away_wins, r.away_losses, r.runs_scored, r.runs_against,r.runs_scored-r.runs_against as "DIFF", r.wins-r.losses as "WLDIFF", r.streak FROM team t JOIN record r ON t.team_id=r.team_id JOIN division d ON t.division_id=d.division_id JOIN league l on t.league_id=l.league_id ORDER BY t.league_id, t.division_id, r.games_behind

American League

TeamRunsLossesPCTGBHomeAwayRSRADIFFWL DiffStreakAL CentralSeattle Mariners30250.5455014-1316-12250238125L2Houston Astros30260.5357120-1110-15233207264L1Texas Rangers27300.4737418-129-18185197-12-3L1Los Angeles Angels25300.4545510-1515-15224280-56-5L5Athletics23340.403589-1914-15235336-101-11L3AL EastNew York Yankees35200.6364018-917-1130519211315W5Tampa Bay Rays29270.5179718-1911-8239209302W2Toronto Blue Jays28280.5000817-1211-16221235-140W2Boston Red Sox27310.46551016-1411-1727526312-4L5Baltimore Orioles19360.3455169-1710-19213310-97-17L2AL WestDetroit Tigers37200.6491021-816-122882048417W4Cleveland Guardians30250.5455615-1015-15223240-175W1Minnesota Twins30250.5455618-812-17216190265L1Kansas City Royals30270.5263718-1112-16188193-53W1Chicago White Sox18380.32141912-156-23196244-48-20W1

National League

TeamRunsLossesPCTGBHomeAwayRSRADIFFWL DiffStreakNL WestLos Angeles Dodgers34220.6071019-815-143142496512L1San Diego Padres31230.5741218-913-14233215188L1San Francisco Giants31250.5536317-914-16242203396L3Arizona Diamondbacks27290.4821714-1513-14279285-6-2L2Colorado Rockies9470.1607256-223-25177352-175-38L5NL EastPhiladelphia Phillies36200.6429019-917-112702313916L1New York Mets34220.6071221-713-152431865712L1Atlanta Braves26290.47271016-910-2022921514-3W1Washington Nationals26300.46431013-1413-16244285-41-4W2Miami Marlins22320.40741313-159-17229305-76-10W1NL CentralChicago Cubs35210.6250018-1017-113302359514W4St. Louis Cardinals32240.5714319-813-16269224458W2Milwaukee Brewers29280.5088718-1011-1824624511W4Cincinnati Reds28290.4912814-1414-1526423232-1L1Pittsburgh Pirates21360.36841513-168-20183243-60-15W2