-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlab-3-3.sql
18 lines (15 loc) · 844 Bytes
/
lab-3-3.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
-- In the modern era (1960-present), how many regular season games did the best team win each season?
-- Challenge: Try to include the team's name in the results. Is it accurate?
-- Expected result: 61 rows, starting with
--
-- +------+-------------------------------+-----------+
-- | 2001 | Seattle Mariners | 116 |
-- | 1998 | New York Yankees | 114 |
-- | 1969 | Baltimore Orioles | 109 |
-- | 1961 | New York Yankees | 109 |
-- | 2018 | Boston Red Sox | 108 |
-- | 1986 | New York Mets | 108 |
-- | 1975 | Cincinnati Reds | 108 |
-- | 1970 | Baltimore Orioles | 108 |
-- | 2019 | Houston Astros | 107 |
-- | 2004 | St. Louis Cardinals | 105 |