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: all tems
| Players           | Role   | Team   |   f price |
|:------------------|:-------|:-------|----------:|
| MS Dhoni          | WKB    | CSK    | 150000000 |
| Suresh Raina      | Bat    | CSK    | 110000000 |
| Ravindra Jadeja   | All    | CSK    |  70000000 |
| Faf du Plessis    | Bat    | CSK    |  16000000 |
| Dwayne Bravo      | All    | CSK    |  64000000 |
| Chaitanya Bishnoi | Bat    | CSK    |   2000000 |
| Dhruv Shorey      | Bat    | CSK    |   2000000 |
| Murali Vijay      | Bat    | CSK    |  20000000 |
| Kedar Jadhav      | All    | CSK    |  78000000 |
| Shane Watson      | All    | CSK    |  40000000 |


Table: bolls
|   POS | PLAYER              |   Mat |   Inns |   Ov |   Runs |   Wkts |   BBI |   Avg |   Econ |    SR |   4w |   5w |
|------:|:--------------------|------:|-------:|-----:|-------:|-------:|------:|------:|-------:|------:|-----:|-----:|
|     3 | Deepak Chahar       |    17 |     17 | 64.3 |    482 |     22 |     0 | 21.9  |   7.47 | 17.59 |    0 |    0 |
|     4 | Shreyas Gopal       |    14 |     14 | 48   |    347 |     20 |     0 | 17.35 |   7.22 | 14.4  |    0 |    0 |
|     5 | Jasprit Bumrah      |    16 |     16 | 61.4 |    409 |     19 |     0 | 21.52 |   6.63 | 19.47 |    0 |    0 |
|     6 | Khaleel Ahmed       |     9 |      9 | 34.5 |    287 |     19 |     0 | 15.1  |   8.23 | 11    |    0 |    0 |
|     7 | Mohammed Shami      |    14 |     14 | 54   |    469 |     19 |     0 | 24.68 |   8.68 | 17.05 |    0 |    0 |
|     9 | Rashid Khan         |    15 |     15 | 60   |    377 |     17 |     0 | 22.17 |   6.28 | 21.17 |    0 |    0 |
|    10 | Harbhajan Singh     |    11 |     11 | 44   |    312 |     16 |     0 | 19.5  |   7.09 | 16.5  |    0 |    0 |
|    12 | Ravindra Jadeja     |    16 |     16 | 54   |    343 |     15 |     0 | 22.86 |   6.35 | 21.6  |    0 |    0 |
|    13 | Ravichandran Ashwin |    14 |     14 | 55   |    400 |     15 |     0 | 26.66 |   7.27 | 22    |    0 |    0 |
|    14 | Hardik Pandya       |    16 |     16 | 42.3 |    390 |     14 |     0 | 27.85 |   9.17 | 18.21 |    0 |    0 |


Table: Chennai Super Kings Squad
| Players           | Role   | Price   | Team   |
|:------------------|:-------|:--------|:-------|
| MS Dhoni          | WKB    | 15 Cr   | CSK    |
| Suresh Raina      | Bat    | 11 Cr   | CSK    |
| Ravindra Jadeja   | All    | 7 Cr    | CSK    |
| Faf du Plessis    | Bat    | 1.6 Cr  | CSK    |
| Dwayne Bravo      | All    | 6.4 Cr  | CSK    |
| Chaitanya Bishnoi | Bat    | 20 Lacs | CSK    |
| Dhruv Shorey      | Bat    | 20 Lacs | CSK    |
| Murali Vijay      | Bat    | 2 Cr    | CSK    |
| Kedar Jadhav      | All    | 7.8 Cr  | CSK    |
| Shane Watson      | All    | 4 Cr    | CSK    |


Table: Delhi Capitals Squad
| Players             | Role   | Price   | Team   |
|:--------------------|:-------|:--------|:-------|
| Shreyas Iyer        | Bat    | 7 Cr    | DC     |
| Shikhar Dhawan      | Bat    | Traded  | DC     |
| Prithvi Shaw        | Bat    | 1.20 Cr | DC     |
| Colin Ingram        | Bat    | 6.40 Cr | DC     |
| Manjot Kalra        | Bat    | 20 Lacs | DC     |
| Jalaj Saxena        | All    | 20 Lacs | DC     |
| Sherfane Rutherford | All    | 2 Cr    | DC     |
| Hanuma Vihari       | All    | 2 Cr    | DC     |
| Colin Munro         | All    | 1.9 Cr  | DC     |
| Ishant Sharma       | Bwl    | 1.10 Cr | DC     |


Table: Kings XI Punjab Squad
| Players             | Role   | Prices   | Team   |
|:--------------------|:-------|:---------|:-------|
| David Miller        | Bat    | 3 Cr     | KIP    |
| Mayank Agarwal      | Bat    | 1 Cr     | KIP    |
| Karun Nair          | Bat    | 5.60 Cr  | KIP    |
| Chris Gayle         | Bat    | 2 Cr     | KIP    |
| Andrew Tye          | Bwl    | 7.20 Cr  | KIP    |
| Mujeeb Ur Rahman    | Bwl    | 4 Cr     | KIP    |
| Ravichandran Ashwin | Bwl    | 7.60 Cr  | KIP    |
| Ankit Rajpoot       | Bwl    | 3 Cr     | KIP    |
| Lokesh Rahul        | WKB    | 11 Cr    | KIP    |
| PrabhSimran Singh   | WKB    | 4.80 Cr  | KIP    |


Table: Kolkata Knight Riders Squad
| Players           | Role   | Price   | Team   |
|:------------------|:-------|:--------|:-------|
| Andre Russell     | All    | 8.5 Cr  | KKR    |
| Sunil Narine      | Bwl    | 12.5 Cr | KKR    |
| Kuldeep Yadav     | Bwl    | 5.8 Cr  | KKR    |
| Piyush Chawla     | All    | 4.20 Cr | KKR    |
| Robin Uthappa     | WKB    | 6.4 Cr  | KKR    |
| Nitish Rana       | Bat    | 3.40 Cr | KKR    |
| Shubman Gill      | Bat    | 1.8 Cr  | KKR    |
| Rinku Singh       | Bat    | 80 Lacs | KKR    |
| Chris Lynn        | Bat    | 9.60 Cr | KKR    |
| Kamlesh Nagarkoti | Bwl    | 3.20 Cr | KKR    |


Table: Mumbai Indians Squad
| Players             | Role   | Price   | Team   |
|:--------------------|:-------|:--------|:-------|
| Rohit Sharma        | Bat    | 15 Cr   | MI     |
| Jasprit Bumrah      | Bwl    | 7 Cr    | MI     |
| Hardik Pandya       | All    | 11 Cr   | MI     |
| Krunal Pandya       | All    | 8.8 Cr  | MI     |
| Kieron Pollard      | All    | 5.4 Cr  | MI     |
| Evin Lewis          | Bat    | 3.8 Cr  | MI     |
| Suryakumar Yadav    | Bat    | 3.2 Cr  | MI     |
| Siddhesh Lad        | Bat    | 20 Lacs | MI     |
| Mayank Markande     | Bat    | 20 Lacs | MI     |
| Anukul Sudhakar Roy | All    | 20 Lacs | MI     |


Table: Rajasthan Royals Squad
| Players         | Role   | Price    | Team   |
|:----------------|:-------|:---------|:-------|
| Steven Smith    | Bat    | 12 Cr    | RR     |
| Ajinkya Rahane  | Bat    | 4 Cr     | RR     |
| Dhawal Kulkarni | Bwl    | 75 Lacs  | RR     |
| Aryaman Birla   | Bat    | 30 Lacs  | RR     |
| Rahul Tripathi  | Bat    | 3.40 Cr  | RR     |
| Stuart Binny    | All    | 50 Lacs  | RR     |
| Mahipal Lomror  | All    | 20 Lacs  | RR     |
| Jaydev Unadkat  | Bwl    | 11.50 Cr | RR     |
| S Midhun        | Bwl    | 20 Lacs  | RR     |
| Shreyas Gopal   | Bwl    | 20 Lacs  | RR     |


Table: Royal Challengers Bangalore Squad
| Players             | Role   | Price   | Team   |
|:--------------------|:-------|:--------|:-------|
| Virat Kohli         | Bat    | 17 Cr   | RCB    |
| AB de Villiers      | Bat    | 11 Cr   | RCB    |
| Yuzvendra Chahal    | Bwl    | 6 Cr    | RCB    |
| Pawan Negi          | All    | 1 Cr    | RCB    |
| Moeen Ali           | All    | 1.70 Cr | RCB    |
| Colin de Grandhomme | All    | 2.20 Cr | RCB    |
| Washington Sundar   | All    | 3.20 Cr | RCB    |
| Nathan Coulter-Nile | Bwl    | 2.20 Cr | RCB    |
| Mohammed Siraj      | Bwl    | 2.60 Cr | RCB    |
| Navdeep Saini       | Bwl    | 3 Cr    | RCB    |


Table: Sunrisers Hyderabad Squads
| Players           | Role   | Price   | Team   |
|:------------------|:-------|:--------|:-------|
| David Warner      | Bat    | 12 Cr   | SRH    |
| Bhuvneshwar Kumar | Bwl    | 8.5 Cr  | SRH    |
| Rashid Khan       | Bwl    | 9 Cr    | SRH    |
| Deepak Hooda      | All    | 3.6 M   | SRH    |
| Ricky Bhui        | Bat    | 20 Lacs | SRH    |
| Manish Pandey     | Bat    | 11 Cr   | SRH    |
| Kane Williamson   | Bat    | 3 Cr    | SRH    |
| Yusuf Pathan      | All    | 1.90 Cr | SRH    |
| Shakib Al Hasan   | All    | 2 Cr    | SRH    |
| Billy Stanlake    | Bwl    | 50 Lacs | SRH    |


Table: t1
| Column1   | Team                            |   Pld |   Won |   Lost |   Tied |   N/R |   Net RR | For         | Against     |   Pts | Form   |
|:----------|:--------------------------------|------:|------:|-------:|-------:|------:|---------:|:------------|:------------|------:|:-------|
| Q         | Mumbai Indians MI               |    14 |     9 |      5 |      0 |     0 |    0.421 | 2,380/275.1 | 2,282/277.2 |    18 | [List] |
| Q         | Chennai Super Kings CSK         |    14 |     9 |      5 |      0 |     0 |    0.131 | 2,043/274.1 | 2,012/274.5 |    18 | [List] |
| Q         | Delhi Capitals DC               |    14 |     9 |      5 |      0 |     0 |    0.044 | 2,207/272.5 | 2,238/278.1 |    18 | [List] |
| Q         | Sunrisers Hyderabad SRH         |    14 |     6 |      8 |      0 |     0 |    0.577 | 2,288/269.2 | 2,200/277.5 |    12 | [List] |
| 5         | Kolkata Knight Riders KKR       |    14 |     6 |      8 |      0 |     0 |    0.028 | 2,466/270.4 | 2,419/266.2 |    12 | [List] |
| 6         | Kings XI Punjab KXIP            |    14 |     6 |      8 |      0 |     0 |   -0.251 | 2,429/276.3 | 2,503/277   |    12 | [List] |
| 7         | Rajasthan Royals RR             |    14 |     5 |      8 |      0 |     1 |   -0.449 | 2,153/257   | 2,192/248.2 |    11 | [List] |
| 8         | Royal Challengers Bangalore RCB |    14 |     5 |      8 |      0 |     1 |   -0.607 | 2,146/258.4 | 2,266/254.3 |    11 | [List] |


Table: Table 0 (2)
|   POS | PLAYER          |   Mat |   Inns |   NO |   Runs | HS   |   Avg |   BF |     SR |   100 |   50 |   4s |   6s |
|------:|:----------------|------:|-------:|-----:|-------:|:-----|------:|-----:|-------:|------:|-----:|-----:|-----:|
|     1 | David Warner    |    12 |     12 |    2 |    692 | 100* | 69.2  |  481 | 143.86 |     1 |    8 |   57 |   21 |
|     2 | KL Rahul        |    14 |     14 |    3 |    593 | 100* | 53.9  |  438 | 135.38 |     1 |    6 |   49 |   25 |
|     3 | Quinton de Kock |    16 |     16 |    1 |    529 | 81   | 35.26 |  398 | 132.91 |     0 |    4 |   45 |   25 |
|     4 | Shikhar Dhawan  |    16 |     16 |    1 |    521 | 97*  | 34.73 |  384 | 135.67 |     0 |    5 |   64 |   11 |
|     5 | Andre Russell   |    14 |     13 |    4 |    510 | 80*  | 56.66 |  249 | 204.81 |     0 |    4 |   31 |   52 |
|     6 | Chris Gayle     |    13 |     13 |    1 |    490 | 99*  | 40.83 |  319 | 153.6  |     0 |    4 |   45 |   34 |
|     7 | Rishabh Pant    |    16 |     16 |    3 |    488 | 78*  | 37.53 |  300 | 162.66 |     0 |    3 |   37 |   27 |
|     8 | Virat Kohli     |    14 |     14 |    0 |    464 | 100  | 33.14 |  328 | 141.46 |     1 |    2 |   46 |   13 |
|     9 | Shreyas Iyer    |    16 |     16 |    1 |    463 | 67   | 30.86 |  386 | 119.94 |     0 |    3 |   41 |   14 |
|    10 | Jonny Bairstow  |    10 |     10 |    2 |    445 | 114  | 55.62 |  283 | 157.24 |     1 |    2 |   48 |   18 |

 


tables: name: all tems
data: all tems.csv
name: bolls
data: bolls.csv
name: Chennai Super Kings Squad
data: Chennai Super Kings Squad.csv
name: Delhi Capitals Squad
data: Delhi Capitals Squad.csv
name: Kings XI Punjab Squad
data: Kings XI Punjab Squad.csv
name: Kolkata Knight Riders Squad
data: Kolkata Knight Riders Squad.csv
name: Mumbai Indians Squad
data: Mumbai Indians Squad.csv
name: Rajasthan Royals Squad
data: Rajasthan Royals Squad.csv
name: Royal Challengers Bangalore Squad
data: Royal Challengers Bangalore Squad.csv
name: Sunrisers Hyderabad Squads
data: Sunrisers Hyderabad Squads.csv
name: t1
data: t1.csv
name: Table 0 (2)
data: Table 0 (2).csv
label: bolls
POS
Table 0 (2)
POS
Chennai Super Kings Squad
Players
all tems
Players
Delhi Capitals Squad
Players
all tems
Players
Kings XI Punjab Squad
Players
all tems
Players
Kolkata Knight Riders Squad
Players
all tems
Players
Mumbai Indians Squad
Players
all tems
Players
Rajasthan Royals Squad
Players
all tems
Players
Royal Challengers Bangalore Squad
Players
all tems
Players
Sunrisers Hyderabad Squads
Players
all tems
Players
output: {
    "joins": [
        {
            "from_table": "bolls",
            "from_column": "POS",
            "to_table": "Table 0 (2)",
            "to_column": "POS"
        },
        {
            "from_table": "Chennai Super Kings Squad",
            "from_column": "Players",
            "to_table": "all tems",
            "to_column": "Players"
        },
        {
            "from_table": "Delhi Capitals Squad",
            "from_column": "Players",
            "to_table": "all tems",
            "to_column": "Players"
        },
        {
            "from_table": "Kings XI Punjab Squad",
            "from_column": "Players",
            "to_table": "all tems",
            "to_column": "Players"
        },
        {
            "from_table": "Kolkata Knight Riders Squad",
            "from_column": "Players",
            "to_table": "all tems",
            "to_column": "Players"
        },
        {
            "from_table": "Mumbai Indians Squad",
            "from_column": "Players",
            "to_table": "all tems",
            "to_column": "Players"
        },
        {
            "from_table": "Rajasthan Royals Squad",
            "from_column": "Players",
            "to_table": "all tems",
            "to_column": "Players"
        },
        {
            "from_table": "Royal Challengers Bangalore Squad",
            "from_column": "Players",
            "to_table": "all tems",
            "to_column": "Players"
        },
        {
            "from_table": "Sunrisers Hyderabad Squads",
            "from_column": "Players",
            "to_table": "all tems",
            "to_column": "Players"
        }
    ]
}