to produce the current W/L records of the MLB teams from the SDQL data.
S(W@1) S(L@1) query
61.0 37.0 Giants and season = 2021
60.0 39.0 Astros and season = 2021
60.0 39.0 Rays and season = 2021
60.0 40.0 Dodgers and season = 2021
60.0 39.0 Red Sox and season = 2021
58.0 39.0 White Sox and season = 2021
58.0 41.0 Brewers and season = 2021
57.0 43.0 Padres and season = 2021
56.0 44.0 Athletics and season = 2021
52.0 46.0 Mariners and season = 2021
51.0 46.0 Reds and season = 2021
51.0 46.0 Yankees and season = 2021
50.0 44.0 Mets and season = 2021
49.0 50.0 Cardinals and season = 2021
48.0 49.0 Angels and season = 2021
48.0 51.0 Cubs and season = 2021
48.0 49.0 Braves and season = 2021
48.0 46.0 Indians and season = 2021
47.0 49.0 Phillies and season = 2021
47.0 45.0 Blue Jays and season = 2021
45.0 53.0 Tigers and season = 2021
44.0 51.0 Nationals and season = 2021
43.0 54.0 Rockies and season = 2021
42.0 57.0 Twins and season = 2021
42.0 56.0 Marlins and season = 2021
41.0 55.0 Royals and season = 2021
38.0 60.0 Pirates and season = 2021
35.0 62.0 Rangers and season = 2021
33.0 64.0 Orioles and season = 2021
31.0 69.0 Diamondbacks and season = 2021
and after doing some research I found some discrepancies which are due to the following missing 9 games in the SDQL MLB database:
I would be happy to help fix this.