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: locations
| Geo         | Region   |
|:------------|:---------|
| India       | APAC     |
| USA         | Americas |
| Canada      | Americas |
| New Zealand | APAC     |
| Australia   | APAC     |
| UK          | Europe   |


Table: people
| Sales person        | Team    | Picture                                       |
|:--------------------|:--------|:----------------------------------------------|
| Barr Faughny        | Yummies | https://files.chandoo.org/pbix/img/men-1.jpg  |
| Dennison Crosswaite | Yummies | https://files.chandoo.org/pbix/img/men-2.jpg  |
| Gunar Cockshoot     | Yummies | https://files.chandoo.org/pbix/img/men-3.jpg  |
| Curtice Advani      | Delish  | https://files.chandoo.org/pbix/img/men-4.jpg  |
| Kaine Padly         | Delish  | https://files.chandoo.org/pbix/img/men-5.jpg  |
| Ches Bonnell        | Delish  | https://files.chandoo.org/pbix/img/men-6.jpg  |
| Brien Boise         | Delish  | https://files.chandoo.org/pbix/img/men-7.jpg  |
| Husein Augar        | Delish  | https://files.chandoo.org/pbix/img/men-8.jpg  |
| Beverie Moffet      | Jucies  | https://files.chandoo.org/pbix/img/men-9.jpg  |
| Oby Sorrel          | Jucies  | https://files.chandoo.org/pbix/img/men-10.jpg |


Table: products
| Product             | Category   |   Cost per box |
|:--------------------|:-----------|---------------:|
| Milk Bars           | Bars       |           5.26 |
| 50% Dark Bites      | Bites      |           7.48 |
| Almond Choco        | Bars       |           5.15 |
| Raspberry Choco     | Bars       |           3.85 |
| Mint Chip Choco     | Bars       |           5.72 |
| Eclairs             | Bites      |           6.31 |
| Drinking Coco       | Other      |           9.94 |
| 99% Dark & Pure     | Bars       |           7.73 |
| Orange Choco        | Bars       |           3.68 |
| Spicy Special Slims | Bites      |           8.22 |


Table: sales
| Sales Person        | Geography   | Product              | Date                    |   Amount |   Customers |   Boxes |    Cost |
|:--------------------|:------------|:---------------------|:------------------------|---------:|------------:|--------:|--------:|
| Dennison Crosswaite | UK          | Almond Choco         | 2021-01-01 00:00:00.000 |     2037 |         456 |     422 | 2173.3  |
| Barr Faughny        | UK          | Orange Choco         | 2021-01-01 00:00:00.000 |     9303 |         177 |      82 |  301.76 |
| Husein Augar        | UK          | Caramel Stuffed Bars | 2021-01-01 00:00:00.000 |     7518 |         174 |       9 |   75.87 |
| Rafaelita Blaksland | UK          | Manuka Honey Choco   | 2021-01-01 00:00:00.000 |     5880 |         118 |      11 |   74.8  |
| Kaine Padly         | UK          | Spicy Special Slims  | 2021-01-01 00:00:00.000 |     1148 |         165 |     285 | 2342.7  |
| Husein Augar        | UK          | After Nines          | 2021-01-01 00:00:00.000 |    10241 |         156 |     377 | 3856.71 |
| Dennison Crosswaite | UK          | 99% Dark & Pure      | 2021-01-01 00:00:00.000 |     3500 |          24 |      46 |  355.58 |
| Curtice Advani      | UK          | Peanut Butter Cubes  | 2021-01-01 00:00:00.000 |     1652 |         248 |     221 |  585.65 |
| Karlen McCaffrey    | UK          | Milk Bars            | 2021-01-01 00:00:00.000 |     5257 |         428 |      45 |  236.7  |
| Curtice Advani      | UK          | Eclairs              | 2021-01-04 00:00:00.000 |     1862 |          92 |     334 | 2107.54 |

 


tables: name: locations
data: locations.csv
name: people
data: people.csv
name: products
data: products.csv
name: sales
data: sales.csv
label: sales
Sales Person
people
Sales person
sales
Product
products
Product
sales
Geography
locations
Geo
output: {
    "joins": [
        {
            "from_table": "sales",
            "from_column": "Sales Person",
            "to_table": "people",
            "to_column": "Sales person"
        },
        {
            "from_table": "sales",
            "from_column": "Product",
            "to_table": "products",
            "to_column": "Product"
        },
        {
            "from_table": "sales",
            "from_column": "Geography",
            "to_table": "locations",
            "to_column": "Geo"
        }
    ]
}