Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Active Franchises
|   Rk | Franchise            |   From |   To | G      | W      | L      |   W-L% |   G>.500 |   Divs |   Pnnts |   WS |   Playoffs |   Players |   HOF# | R      | AB      | H       | HR     |    BA | RA     |   ERA | TEAM_ID   | Team URL                                                                  |
|-----:|:---------------------|-------:|-----:|:-------|:-------|:-------|-------:|---------:|-------:|--------:|-----:|-----------:|----------:|-------:|:-------|:--------|:--------|:-------|------:|:-------|------:|:----------|:--------------------------------------------------------------------------|
|    1 | Arizona Diamondbacks |   1998 | 2018 | 3,401  | 1,678  | 1,723  |  0.493 |      -45 |      5 |       1 |    1 |          6 |       469 |      2 | 15,407 | 116,310 | 29,897  | 3,571  | 0.257 | 15,566 |  4.21 | ARI       | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/ARI-2018.png |
|    2 | Atlanta Braves       |   1876 | 2018 | 21,347 | 10,600 | 10,593 |  0.5   |        7 |     17 |      17 |    3 |         23 |      1997 |     52 | 94,891 | 731,069 | 190,018 | 13,651 | 0.26  | 94,190 |  3.66 | ATL       | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/ATL-2018.png |
|    3 | Baltimore Orioles    |   1901 | 2018 | 18,443 | 8,713  | 9,620  |  0.475 |     -907 |      9 |       7 |    3 |         14 |      1831 |     31 | 79,488 | 626,544 | 162,073 | 13,305 | 0.259 | 84,504 |  4.02 | BAL       | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/BAL-2018.png |
|    4 | Boston Red Sox       |   1901 | 2018 | 18,430 | 9,517  | 8,830  |  0.519 |      687 |      9 |      13 |    8 |         23 |      1795 |     36 | 85,851 | 630,516 | 168,472 | 13,465 | 0.267 | 82,318 |  3.9  | BOS       | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/BOS-2018.png |
|    5 | Chicago Cubs         |   1876 | 2018 | 21,383 | 10,897 | 10,325 |  0.513 |      572 |      7 |      17 |    3 |         19 |      2074 |     44 | 98,423 | 732,453 | 192,379 | 14,117 | 0.263 | 94,978 |  3.68 | CHC       | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/CHC-2018.png |
|    6 | Chicago White Sox    |   1901 | 2018 | 18,439 | 9,211  | 9,125  |  0.502 |       86 |      5 |       6 |    3 |          9 |      1764 |     31 | 80,274 | 624,444 | 162,553 | 11,328 | 0.26  | 79,928 |  3.77 | CHW       | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/CHW-2018.png |
|    7 | Cincinnati Reds      |   1882 | 2018 | 20,968 | 10,524 | 10,305 |  0.505 |      219 |     10 |      10 |    5 |         15 |      1994 |     35 | 94,134 | 715,189 | 186,969 | 13,203 | 0.261 | 93,213 |  3.74 | CIN       | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/CIN-2018.png |
|    8 | Cleveland Indians    |   1901 | 2018 | 18,442 | 9,383  | 8,968  |  0.511 |      415 |      9 |       6 |    2 |         13 |      1875 |     33 | 83,527 | 629,163 | 167,181 | 12,945 | 0.266 | 81,547 |  3.83 | CLE       | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/CLE-2018.png |
|    9 | Colorado Rockies     |   1993 | 2018 | 4,149  | 1,961  | 2,188  |  0.473 |     -227 |      0 |       1 |    0 |          4 |       564 |      0 | 20,947 | 142,825 | 39,196  | 4,719  | 0.274 | 21,788 |  4.95 | COL       | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/COL-2018.png |
|   10 | Detroit Tigers       |   1901 | 2018 | 18,468 | 9,299  | 9,076  |  0.506 |      223 |      7 |      11 |    4 |         16 |      1678 |     24 | 85,334 | 630,276 | 167,324 | 13,693 | 0.265 | 84,441 |  3.98 | DET       | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/DET-2018.png |


Table: League
| League   | URL                                                                                                                       |
|:---------|:--------------------------------------------------------------------------------------------------------------------------|
| AL       | https://upload.wikimedia.org/wikipedia/en/thumb/5/54/American_League_logo.svg/1200px-American_League_logo.svg.png         |
| NL       | https://upload.wikimedia.org/wikipedia/en/thumb/d/d4/MLB_National_League_logo.svg/1200px-MLB_National_League_logo.svg.png |


Table: Player Batting
| Team   | League   |   G |   PA |   AB |   R |   H |   2B |   3B |   HR |   RBI |   SB |   CS |   BB |   SO | BA   | OBP   | SLG   | OPS   | OPS+   |   TB |   GDP |   HBP |   SH |   SF |   IBB |   Season | Position   | Bats   | Player Name      |
|:-------|:---------|----:|-----:|-----:|----:|----:|-----:|-----:|-----:|------:|-----:|-----:|-----:|-----:|:-----|:------|:------|:------|:-------|-----:|------:|------:|-----:|-----:|------:|---------:|:-----------|:-------|:-----------------|
| KCR    | AL       |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |     2018 | P          | R      | Jason Adam       |
| NYY    | AL       |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |     2018 | P          | R      | Chance Adams     |
| DET    | AL       |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |     2018 | P          | R      | Victor Alcantara |
| SEA    | AL       |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |     2018 | P          | R      | Shawn Armstrong  |
| TOR    | AL       |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |     2018 | P          | R      | John Axford      |
| DET    | AL       |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |     2018 | P          | R      | Johnny Barbato   |
| TEX    | AL       |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |     2018 | P          | R      | Tony Barnette    |
| LAA    | AL       |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |     2018 | P          | R      | Taylor Cole      |
| HOU    | AL       |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |     2018 | P          | R      | Chris Devenski   |
| CLE    | AL       |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |     2018 | P          | R      | Oliver Drake     |


Table: Player Standard Batting 2016
|   Rk | Name           |   Age | Tm   | Lg   |   G |   PA |   AB |   R |   H |   2B |   3B |   HR |   RBI |   SB |   CS |   BB |   SO | BA   | OBP   | SLG   | OPS   | OPS+   |   TB |   GDP |   HBP |   SH |   SF |   IBB |   Pos Summary |   Season |
|-----:|:---------------|------:|:-----|:-----|----:|-----:|-----:|----:|----:|-----:|-----:|-----:|------:|-----:|-----:|-----:|-----:|:-----|:------|:------|:------|:-------|-----:|------:|------:|-----:|-----:|------:|--------------:|---------:|
|    3 | Fernando Abad* |    30 | BOS  | AL   |   2 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2016 |
|    5 | A.J. Achter    |    27 | LAA  | AL   |   3 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2016 |
|   17 | Cody Allen     |    27 | CLE  | AL   |   6 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2016 |
|   26 | Dario Alvarez* |    27 | TEX  | AL   |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2016 |
|   58 | John Axford    |    33 | OAK  | AL   |   6 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2016 |
|   71 | Matt Barnes    |    26 | BOS  | AL   |   2 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2016 |
|   72 | Tony Barnette  |    32 | TEX  | AL   |   2 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2016 |
|   83 | Chris Beck     |    25 | CHW  | AL   |   2 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2016 |
|   88 | Cam Bedrosian  |    24 | LAA  | AL   |   5 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2016 |
|   98 | Joaquin Benoit |    38 | SEA  | AL   |   2 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2016 |


Table: Player Standard Batting 2017
|   Rk | Name            |   Age | Tm   | Lg   |   G |   PA |   AB |   R |   H |   2B |   3B |   HR |   RBI |   SB |   CS |   BB |   SO | BA   | OBP   | SLG   | OPS   | OPS+   |   TB |   GDP |   HBP |   SH |   SF |   IBB |   Pos Summary |   Season |
|-----:|:----------------|------:|:-----|:-----|----:|-----:|-----:|----:|----:|-----:|-----:|-----:|------:|-----:|-----:|-----:|-----:|:-----|:------|:------|:------|:-------|-----:|------:|------:|-----:|-----:|------:|--------------:|---------:|
|    1 | Fernando Abad*  |    31 | BOS  | AL   |   4 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2017 |
|   18 | Al Alburquerque |    31 | KCR  | AL   |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2017 |
|   24 | Cody Allen      |    28 | CLE  | AL   |   5 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2017 |
|   31 | Dan Altavilla   |    24 | SEA  | AL   |   5 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2017 |
|   35 | Jose Alvarez*   |    28 | LAA  | AL   |   5 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2017 |
|   57 | Shawn Armstrong |    26 | CLE  | AL   |   3 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2017 |
|   71 | John Axford     |    34 | OAK  | AL   |   3 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2017 |
|   82 | Danny Barnes*   |    27 | TOR  | AL   |   4 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2017 |
|   84 | Matt Barnes     |    27 | BOS  | AL   |   4 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2017 |
|   85 | Tony Barnette   |    33 | TEX  | AL   |   3 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2017 |


Table: Player Standard Batting 2018
|   Rk | Name             |   Age | Tm   | Lg   |   G |   PA |   AB |   R |   H |   2B |   3B |   HR |   RBI |   SB |   CS |   BB |   SO | BA   | OBP   | SLG   | OPS   | OPS+   |   TB |   GDP |   HBP |   SH |   SF |   IBB |   Pos Summary |   Season |
|-----:|:-----------------|------:|:-----|:-----|----:|-----:|-----:|----:|----:|-----:|-----:|-----:|------:|-----:|-----:|-----:|-----:|:-----|:------|:------|:------|:-------|-----:|------:|------:|-----:|-----:|------:|--------------:|---------:|
|    3 | Jason Adam       |    26 | KCR  | AL   |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2018 |
|   19 | Victor Alcantara |    25 | DET  | AL   |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2018 |
|   24 | Cody Allen       |    29 | CLE  | AL   |   4 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2018 |
|   33 | Jose Alvarez*    |    29 | LAA  | AL   |   5 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2018 |
|   39 | Justin Anderson* |    25 | LAA  | AL   |   6 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2018 |
|   47 | Matt Andriese    |    28 | TBR  | AL   |   2 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2018 |
|   58 | Shawn Armstrong  |    27 | SEA  | AL   |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2018 |
|   73 | John Axford      |    35 | TOR  | AL   |   1 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2018 |
|   83 | Danny Barnes*    |    28 | TOR  | AL   |   3 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2018 |
|   85 | Matt Barnes      |    28 | BOS  | AL   |   4 |    0 |    0 |   0 |   0 |    0 |    0 |    0 |     0 |    0 |    0 |    0 |    0 |      |       |       |       |        |    0 |     0 |     0 |    0 |    0 |     0 |             1 |     2018 |


Table: Team Batting
| Tm   |   #Bat |   BatAge |   R/G |   G |   PA |   AB |   R |    H |   2B |   3B |   HR |   RBI |   SB |   CS |   BB |   SO |    BA |   OBP |   SLG |   OPS |   OPS+ |   TB |   GDP |   HBP |   SH |   SF |   IBB |   LOB |   Season | Team URL                                                                  |
|:-----|-------:|---------:|------:|----:|-----:|-----:|----:|-----:|-----:|-----:|-----:|------:|-----:|-----:|-----:|-----:|------:|------:|------:|------:|-------:|-----:|------:|------:|-----:|-----:|------:|------:|---------:|:--------------------------------------------------------------------------|
| ARI  |     49 |     29.2 |  4.29 | 161 | 6122 | 5427 | 690 | 1277 |  259 |   50 |  174 |   655 |   78 |   24 |  559 | 1447 | 0.235 | 0.31  | 0.398 | 0.708 |     84 | 2158 |   109 |    52 |   38 |   44 |    36 |  1084 |     2018 | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/ARI-2018.png |
| ATL  |     58 |     27.3 |  4.71 | 161 | 6216 | 5551 | 758 | 1429 |  312 |   29 |  175 |   716 |   90 |   36 |  507 | 1274 | 0.257 | 0.325 | 0.419 | 0.743 |    100 | 2324 |    99 |    66 |   49 |   43 |    53 |  1136 |     2018 | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/ATL-2018.png |
| BAL  |     56 |     28.4 |  3.84 | 161 | 6001 | 5476 | 618 | 1309 |  238 |   15 |  188 |   590 |   79 |   22 |  421 | 1402 | 0.239 | 0.298 | 0.391 | 0.689 |     91 | 2141 |   131 |    56 |   13 |   35 |    19 |  1022 |     2018 | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/BAL-2018.png |
| BOS  |     44 |     27.7 |  5.38 | 161 | 6260 | 5586 | 866 | 1496 |  350 |   31 |  206 |   821 |  125 |   31 |  564 | 1242 | 0.268 | 0.338 | 0.452 | 0.79  |    111 | 2526 |   129 |    55 |    7 |   48 |    38 |  1116 |     2018 | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/BOS-2018.png |
| CHC  |     50 |     27.2 |  4.66 | 161 | 6297 | 5561 | 750 | 1438 |  281 |   33 |  165 |   713 |   66 |   38 |  567 | 1372 | 0.259 | 0.333 | 0.41  | 0.743 |     95 | 2280 |   104 |    78 |   40 |   46 |    66 |  1214 |     2018 | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/CHC-2018.png |
| CHW  |     51 |     26.5 |  4.05 | 161 | 6033 | 5491 | 652 | 1325 |  256 |   40 |  182 |   635 |   98 |   41 |  422 | 1579 | 0.241 | 0.302 | 0.402 | 0.703 |     93 | 2207 |    99 |    65 |   23 |   31 |    18 |  1043 |     2018 | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/CHW-2018.png |
| CIN  |     53 |     27.2 |  4.29 | 161 | 6199 | 5497 | 691 | 1399 |  250 |   25 |  170 |   662 |   75 |   33 |  554 | 1360 | 0.255 | 0.328 | 0.402 | 0.73  |     94 | 2209 |   127 |    64 |   49 |   35 |    35 |  1173 |     2018 | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/CIN-2018.png |
| CLE  |     49 |     29.4 |  5.07 | 161 | 6262 | 5562 | 816 | 1442 |  296 |   19 |  215 |   786 |  132 |   36 |  550 | 1181 | 0.259 | 0.332 | 0.435 | 0.767 |    105 | 2421 |    97 |    79 |   25 |   44 |    32 |  1138 |     2018 | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/CLE-2018.png |
| COL  |     41 |     28.7 |  4.76 | 161 | 6101 | 5477 | 766 | 1401 |  278 |   41 |  203 |   734 |   94 |   32 |  498 | 1384 | 0.256 | 0.322 | 0.433 | 0.754 |     90 | 2370 |   114 |    50 |   40 |   36 |    38 |  1055 |     2018 | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/COL-2018.png |
| DET  |     49 |     27.9 |  3.91 | 161 | 5995 | 5461 | 630 | 1320 |  282 |   35 |  135 |   597 |   70 |   30 |  427 | 1331 | 0.242 | 0.301 | 0.38  | 0.681 |     85 | 2077 |   109 |    52 |   15 |   40 |    18 |  1064 |     2018 | https://d2p3bygnnzw9w3.cloudfront.net/req/201809201/tlogo/br/DET-2018.png |


Table: Team Standard Batting Table 2016
| Tm   |   #Bat |   BatAge |   R/G |   G |   PA |   AB |   R |    H |   2B |   3B |   HR |   RBI |   SB |   CS |   BB |   SO |    BA |   OBP |   SLG |   OPS |   OPS+ |   TB |   GDP |   HBP |   SH |   SF |   IBB |   LOB |   Season |
|:-----|-------:|---------:|------:|----:|-----:|-----:|----:|-----:|-----:|-----:|-----:|------:|-----:|-----:|-----:|-----:|------:|------:|------:|------:|-------:|-----:|------:|------:|-----:|-----:|------:|------:|---------:|
| ARI  |     50 |     26.7 |  4.64 | 162 | 6260 | 5665 | 752 | 1479 |  285 |   56 |  190 |   709 |  137 |   31 |  463 | 1427 | 0.261 | 0.32  | 0.432 | 0.752 |     93 | 2446 |   117 |    50 |   43 |   38 |    43 |  1113 |     2016 |
| ATL  |     60 |     28.9 |  4.03 | 161 | 6192 | 5514 | 649 | 1404 |  295 |   27 |  122 |   615 |   75 |   34 |  502 | 1240 | 0.255 | 0.321 | 0.384 | 0.705 |     89 | 2119 |   145 |    59 |   64 |   52 |    60 |  1160 |     2016 |
| BAL  |     47 |     28.5 |  4.59 | 162 | 6089 | 5524 | 744 | 1413 |  265 |    6 |  253 |   710 |   19 |   13 |  468 | 1324 | 0.256 | 0.317 | 0.443 | 0.76  |    101 | 2449 |   119 |    44 |   17 |   36 |    19 |  1065 |     2016 |
| BOS  |     50 |     28.5 |  5.42 | 162 | 6320 | 5670 | 878 | 1598 |  343 |   25 |  208 |   836 |   83 |   24 |  558 | 1160 | 0.282 | 0.348 | 0.461 | 0.81  |    112 | 2615 |   137 |    43 |    8 |   40 |    34 |  1162 |     2016 |
| CHC  |     45 |     27.4 |  4.99 | 162 | 6335 | 5503 | 808 | 1409 |  293 |   30 |  199 |   767 |   66 |   34 |  656 | 1339 | 0.256 | 0.343 | 0.429 | 0.772 |    104 | 2359 |   107 |    96 |   42 |   37 |    45 |  1217 |     2016 |
| CHW  |     50 |     28.3 |  4.23 | 162 | 6131 | 5550 | 686 | 1428 |  277 |   33 |  168 |   656 |   77 |   36 |  455 | 1285 | 0.257 | 0.317 | 0.41  | 0.727 |     99 | 2275 |   122 |    53 |   29 |   44 |    16 |  1105 |     2016 |
| CIN  |     52 |     27.8 |  4.42 | 162 | 6094 | 5487 | 716 | 1403 |  277 |   33 |  164 |   678 |  139 |   51 |  452 | 1284 | 0.256 | 0.316 | 0.408 | 0.724 |     91 | 2238 |   129 |    52 |   58 |   44 |    37 |  1014 |     2016 |
| CLE  |     48 |     29   |  4.83 | 161 | 6155 | 5484 | 777 | 1435 |  308 |   29 |  185 |   733 |  134 |   31 |  531 | 1246 | 0.262 | 0.329 | 0.43  | 0.759 |     96 | 2356 |   137 |    49 |   31 |   60 |    16 |  1084 |     2016 |
| COL  |     47 |     27.8 |  5.22 | 162 | 6236 | 5614 | 845 | 1544 |  318 |   47 |  204 |   805 |   66 |   39 |  494 | 1330 | 0.275 | 0.336 | 0.457 | 0.794 |     97 | 2568 |   113 |    40 |   54 |   34 |    35 |  1089 |     2016 |
| DET  |     44 |     29.9 |  4.66 | 161 | 6127 | 5526 | 750 | 1476 |  252 |   30 |  211 |   719 |   58 |   29 |  493 | 1303 | 0.267 | 0.331 | 0.438 | 0.769 |    106 | 2421 |   135 |    53 |   17 |   38 |    32 |  1105 |     2016 |


Table: Team Standard Batting Table 2017
| Tm   |   #Bat |   BatAge |   R/G |   G |   PA |   AB |   R |    H |   2B |   3B |   HR |   RBI |   SB |   CS |   BB |   SO |    BA |   OBP |   SLG |   OPS |   OPS+ |   TB |   GDP |   HBP |   SH |   SF |   IBB |   LOB |   Season |
|:-----|-------:|---------:|------:|----:|-----:|-----:|----:|-----:|-----:|-----:|-----:|------:|-----:|-----:|-----:|-----:|------:|------:|------:|------:|-------:|-----:|------:|------:|-----:|-----:|------:|------:|---------:|
| ARI  |     45 |     28.3 |  5.01 | 162 | 6224 | 5525 | 812 | 1405 |  314 |   39 |  220 |   776 |  103 |   30 |  578 | 1456 | 0.254 | 0.329 | 0.445 | 0.774 |     94 | 2457 |   106 |    54 |   39 |   27 |    44 |  1118 |     2017 |
| ATL  |     49 |     28.7 |  4.52 | 162 | 6216 | 5584 | 732 | 1467 |  289 |   26 |  165 |   706 |   77 |   31 |  474 | 1184 | 0.263 | 0.326 | 0.412 | 0.738 |     92 | 2303 |   137 |    66 |   59 |   32 |    57 |  1127 |     2017 |
| BAL  |     50 |     28.6 |  4.59 | 162 | 6140 | 5650 | 743 | 1469 |  269 |   12 |  232 |   713 |   32 |   13 |  392 | 1412 | 0.26  | 0.312 | 0.435 | 0.747 |     99 | 2458 |   138 |    50 |   10 |   37 |    12 |  1041 |     2017 |
| BOS  |     49 |     27.3 |  4.85 | 162 | 6338 | 5669 | 785 | 1461 |  302 |   19 |  168 |   735 |  106 |   31 |  571 | 1224 | 0.258 | 0.329 | 0.407 | 0.736 |     93 | 2305 |   141 |    53 |    9 |   36 |    48 |  1134 |     2017 |
| CHC  |     47 |     27.1 |  5.07 | 162 | 6283 | 5496 | 822 | 1402 |  274 |   29 |  223 |   785 |   62 |   31 |  622 | 1401 | 0.255 | 0.338 | 0.437 | 0.775 |     99 | 2403 |   134 |    82 |   48 |   32 |    54 |  1147 |     2017 |
| CHW  |     51 |     26.7 |  4.36 | 162 | 6059 | 5513 | 706 | 1412 |  256 |   37 |  186 |   670 |   71 |   31 |  401 | 1397 | 0.256 | 0.314 | 0.417 | 0.731 |     96 | 2300 |   124 |    76 |   35 |   33 |    17 |  1055 |     2017 |
| CIN  |     47 |     27.1 |  4.65 | 162 | 6213 | 5484 | 753 | 1390 |  249 |   38 |  219 |   715 |  120 |   39 |  565 | 1329 | 0.253 | 0.329 | 0.433 | 0.761 |     97 | 2372 |   116 |    72 |   50 |   42 |    41 |  1135 |     2017 |
| CLE  |     41 |     28   |  5.05 | 162 | 6234 | 5511 | 818 | 1449 |  333 |   29 |  212 |   780 |   88 |   23 |  604 | 1153 | 0.263 | 0.339 | 0.449 | 0.788 |    104 | 2476 |   125 |    50 |   23 |   45 |    30 |  1158 |     2017 |
| COL  |     41 |     28.3 |  5.09 | 162 | 6201 | 5534 | 824 | 1510 |  293 |   38 |  192 |   793 |   59 |   34 |  519 | 1408 | 0.273 | 0.338 | 0.444 | 0.781 |     90 | 2455 |   143 |    44 |   62 |   41 |    46 |  1088 |     2017 |
| DET  |     49 |     29.6 |  4.54 | 162 | 6150 | 5556 | 735 | 1435 |  289 |   35 |  187 |   699 |   65 |   34 |  503 | 1313 | 0.258 | 0.324 | 0.424 | 0.748 |     98 | 2355 |   128 |    52 |   11 |   27 |    21 |  1104 |     2017 |


Table: Team Standard Batting Table 2018
| Tm   |   #Bat |   BatAge |   R/G |   G |   PA |   AB |   R |    H |   2B |   3B |   HR |   RBI |   SB |   CS |   BB |   SO |    BA |   OBP |   SLG |   OPS |   OPS+ |   TB |   GDP |   HBP |   SH |   SF |   IBB |   LOB |   Season |
|:-----|-------:|---------:|------:|----:|-----:|-----:|----:|-----:|-----:|-----:|-----:|------:|-----:|-----:|-----:|-----:|------:|------:|------:|------:|-------:|-----:|------:|------:|-----:|-----:|------:|------:|---------:|
| ARI  |     49 |     29.2 |  4.29 | 161 | 6122 | 5427 | 690 | 1277 |  259 |   50 |  174 |   655 |   78 |   24 |  559 | 1447 | 0.235 | 0.31  | 0.398 | 0.708 |     84 | 2158 |   109 |    52 |   38 |   44 |    36 |  1084 |     2018 |
| ATL  |     58 |     27.3 |  4.71 | 161 | 6216 | 5551 | 758 | 1429 |  312 |   29 |  175 |   716 |   90 |   36 |  507 | 1274 | 0.257 | 0.325 | 0.419 | 0.743 |    100 | 2324 |    99 |    66 |   49 |   43 |    53 |  1136 |     2018 |
| BAL  |     56 |     28.4 |  3.84 | 161 | 6001 | 5476 | 618 | 1309 |  238 |   15 |  188 |   590 |   79 |   22 |  421 | 1402 | 0.239 | 0.298 | 0.391 | 0.689 |     91 | 2141 |   131 |    56 |   13 |   35 |    19 |  1022 |     2018 |
| BOS  |     44 |     27.7 |  5.38 | 161 | 6260 | 5586 | 866 | 1496 |  350 |   31 |  206 |   821 |  125 |   31 |  564 | 1242 | 0.268 | 0.338 | 0.452 | 0.79  |    111 | 2526 |   129 |    55 |    7 |   48 |    38 |  1116 |     2018 |
| CHC  |     50 |     27.2 |  4.66 | 161 | 6297 | 5561 | 750 | 1438 |  281 |   33 |  165 |   713 |   66 |   38 |  567 | 1372 | 0.259 | 0.333 | 0.41  | 0.743 |     95 | 2280 |   104 |    78 |   40 |   46 |    66 |  1214 |     2018 |
| CHW  |     51 |     26.5 |  4.05 | 161 | 6033 | 5491 | 652 | 1325 |  256 |   40 |  182 |   635 |   98 |   41 |  422 | 1579 | 0.241 | 0.302 | 0.402 | 0.703 |     93 | 2207 |    99 |    65 |   23 |   31 |    18 |  1043 |     2018 |
| CIN  |     53 |     27.2 |  4.29 | 161 | 6199 | 5497 | 691 | 1399 |  250 |   25 |  170 |   662 |   75 |   33 |  554 | 1360 | 0.255 | 0.328 | 0.402 | 0.73  |     94 | 2209 |   127 |    64 |   49 |   35 |    35 |  1173 |     2018 |
| CLE  |     49 |     29.4 |  5.07 | 161 | 6262 | 5562 | 816 | 1442 |  296 |   19 |  215 |   786 |  132 |   36 |  550 | 1181 | 0.259 | 0.332 | 0.435 | 0.767 |    105 | 2421 |    97 |    79 |   25 |   44 |    32 |  1138 |     2018 |
| COL  |     41 |     28.7 |  4.76 | 161 | 6101 | 5477 | 766 | 1401 |  278 |   41 |  203 |   734 |   94 |   32 |  498 | 1384 | 0.256 | 0.322 | 0.433 | 0.754 |     90 | 2370 |   114 |    50 |   40 |   36 |    38 |  1055 |     2018 |
| DET  |     49 |     27.9 |  3.91 | 161 | 5995 | 5461 | 630 | 1320 |  282 |   35 |  135 |   597 |   70 |   30 |  427 | 1331 | 0.242 | 0.301 | 0.38  | 0.681 |     85 | 2077 |   109 |    52 |   15 |   40 |    18 |  1064 |     2018 |

 


tables: name: Active Franchises
data: Active Franchises.csv
name: League
data: League.csv
name: Player Batting
data: Player Batting.csv
name: Player Standard Batting 2016
data: Player Standard Batting 2016.csv
name: Player Standard Batting 2017
data: Player Standard Batting 2017.csv
name: Player Standard Batting 2018
data: Player Standard Batting 2018.csv
name: Team Batting
data: Team Batting.csv
name: Team Standard Batting Table 2016
data: Team Standard Batting Table 2016.csv
name: Team Standard Batting Table 2017
data: Team Standard Batting Table 2017.csv
name: Team Standard Batting Table 2018
data: Team Standard Batting Table 2018.csv
label: Player Standard Batting 2018
Tm
Team Standard Batting Table 2018
Tm
Player Standard Batting 2017
Tm
Team Standard Batting Table 2018
Tm
Player Standard Batting 2016
Tm
Team Standard Batting Table 2018
Tm
Player Batting
Team
Team Standard Batting Table 2018
Tm
Team Batting
Tm
Team Standard Batting Table 2018
Tm
Player Standard Batting 2018
Tm
Team Standard Batting Table 2017
Tm
Player Standard Batting 2017
Tm
Team Standard Batting Table 2017
Tm
Player Standard Batting 2016
Tm
Team Standard Batting Table 2017
Tm
Player Batting
Team
Team Standard Batting Table 2017
Tm
Team Batting
Tm
Team Standard Batting Table 2017
Tm
Player Standard Batting 2018
Tm
Team Standard Batting Table 2016
Tm
Player Standard Batting 2017
Tm
Team Standard Batting Table 2016
Tm
Player Standard Batting 2016
Tm
Team Standard Batting Table 2016
Tm
Player Batting
Team
Team Standard Batting Table 2016
Tm
Team Batting
Tm
Team Standard Batting Table 2016
Tm
Player Batting
Team
Active Franchises
TEAM_ID
Team Batting
Tm
Active Franchises
TEAM_ID
Player Batting
League
League
League
output: {
    "joins": [
        {
            "from_table": "Player Standard Batting 2018",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2018",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Standard Batting 2017",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2018",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Standard Batting 2016",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2018",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Batting",
            "from_column": "Team",
            "to_table": "Team Standard Batting Table 2018",
            "to_column": "Tm"
        },
        {
            "from_table": "Team Batting",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2018",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Standard Batting 2018",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2017",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Standard Batting 2017",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2017",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Standard Batting 2016",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2017",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Batting",
            "from_column": "Team",
            "to_table": "Team Standard Batting Table 2017",
            "to_column": "Tm"
        },
        {
            "from_table": "Team Batting",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2017",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Standard Batting 2018",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2016",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Standard Batting 2017",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2016",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Standard Batting 2016",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2016",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Batting",
            "from_column": "Team",
            "to_table": "Team Standard Batting Table 2016",
            "to_column": "Tm"
        },
        {
            "from_table": "Team Batting",
            "from_column": "Tm",
            "to_table": "Team Standard Batting Table 2016",
            "to_column": "Tm"
        },
        {
            "from_table": "Player Batting",
            "from_column": "Team",
            "to_table": "Active Franchises",
            "to_column": "TEAM_ID"
        },
        {
            "from_table": "Team Batting",
            "from_column": "Tm",
            "to_table": "Active Franchises",
            "to_column": "TEAM_ID"
        },
        {
            "from_table": "Player Batting",
            "from_column": "League",
            "to_table": "League",
            "to_column": "League"
        }
    ]
}