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: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (2)
| Movie Title                          | Genre     | MPAA Rating   |   Total Gross |   Inflation Adjusted Gross |   Year |   Day of Week |
|:-------------------------------------|:----------|:--------------|--------------:|---------------------------:|-------:|--------------:|
| Star Wars Ep. VII: The Force Awakens | Adventure | PG-13         |     936662225 |                  936662225 |   2015 |             4 |
| The Avengers                         | Action    | PG-13         |     623279547 |                  660081224 |   2012 |             4 |
| Rogue One: A Star Wars Story         | Adventure | PG-13         |     529483936 |                  529483936 |   2016 |             4 |
| Finding Dory                         | Adventure | PG            |     486295561 |                  486295561 |   2016 |             4 |
| Avengers: Age of Ultron              | Action    | PG-13         |     459005868 |                  459005868 |   2015 |             4 |


Table: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (3)
| Genre             |   Total Gross |
|:------------------|--------------:|
| Adventure         |   16389069453 |
| Comedy            |    8119619678 |
| Action            |    4184563282 |
| Drama             |    4106972970 |
| Thriller/Suspense |    1406806519 |
| Musical           |    1157284155 |
| Romantic Comedy   |    1152206855 |
| Western           |     359011459 |
| Documentary       |     180685619 |
| Unknown           |     118047013 |


Table: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (4)
| Movie Title                   | Genre   | MPAA Rating   |   Total Gross |   Inflation Adjusted Gross |   Year |   Month |   Week of Month |   Day of Week | Date Released           | Day Name   |   Year (bins) |
|:------------------------------|:--------|:--------------|--------------:|---------------------------:|-------:|--------:|----------------:|--------------:|:------------------------|:-----------|--------------:|
| Freaky Friday                 | Comedy  | Unknown       |      25942000 |                   98067733 |   1977 |       1 |               4 |             4 | 1977-01-21 00:00:00.000 | Friday     |          1975 |
| The Fox and the Hound         | Comedy  | Unknown       |      43899231 |                  133118889 |   1981 |       7 |               2 |             4 | 1981-07-10 00:00:00.000 | Friday     |          1980 |
| Trenchcoat                    | Comedy  | Unknown       |       4304286 |                   11519089 |   1983 |       3 |               2 |             4 | 1983-03-11 00:00:00.000 | Friday     |          1980 |
| Splash                        | Comedy  | PG            |      62599495 |                  157057661 |   1984 |       3 |               2 |             4 | 1984-03-09 00:00:00.000 | Friday     |          1980 |
| My Science Project            | Comedy  | Unknown       |       4100000 |                    9736051 |   1985 |       8 |               2 |             4 | 1985-08-09 00:00:00.000 | Friday     |          1985 |
| Down and Out in Beverly Hills | Comedy  | R             |      62134225 |                  141183693 |   1986 |       1 |               5 |             4 | 1986-01-31 00:00:00.000 | Friday     |          1985 |
| Off Beat                      | Comedy  | Unknown       |       4842778 |                   11003932 |   1986 |       4 |               2 |             4 | 1986-04-11 00:00:00.000 | Friday     |          1985 |
| Ruthless People               | Comedy  | R             |      71624879 |                  162748712 |   1986 |       6 |               5 |             4 | 1986-06-27 00:00:00.000 | Friday     |          1985 |
| Tough Guys                    | Comedy  | Unknown       |      21458229 |                   48758184 |   1986 |      10 |               1 |             4 | 1986-10-03 00:00:00.000 | Friday     |          1985 |
| Outrageous Fortune            | Comedy  | R             |      52864741 |                  113976921 |   1987 |       1 |               5 |             4 | 1987-01-30 00:00:00.000 | Friday     |          1985 |


Table: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross
| Movie Title                   | Date Released           | Genre   | MPAA Rating   |   Total Gross |   Inflation Adjusted Gross |   Year |   Month |   Week of Month |   Day of Week |   Year (bins) |
|:------------------------------|:------------------------|:--------|:--------------|--------------:|---------------------------:|-------:|--------:|----------------:|--------------:|--------------:|
| Freaky Friday                 | 1977-01-21 00:00:00.000 | Comedy  | Unknown       |      25942000 |                   98067733 |   1977 |       1 |               4 |             4 |          1975 |
| The Fox and the Hound         | 1981-07-10 00:00:00.000 | Comedy  | Unknown       |      43899231 |                  133118889 |   1981 |       7 |               2 |             4 |          1980 |
| Trenchcoat                    | 1983-03-11 00:00:00.000 | Comedy  | Unknown       |       4304286 |                   11519089 |   1983 |       3 |               2 |             4 |          1980 |
| Splash                        | 1984-03-09 00:00:00.000 | Comedy  | PG            |      62599495 |                  157057661 |   1984 |       3 |               2 |             4 |          1980 |
| My Science Project            | 1985-08-09 00:00:00.000 | Comedy  | Unknown       |       4100000 |                    9736051 |   1985 |       8 |               2 |             4 |          1985 |
| Down and Out in Beverly Hills | 1986-01-31 00:00:00.000 | Comedy  | R             |      62134225 |                  141183693 |   1986 |       1 |               5 |             4 |          1985 |
| Off Beat                      | 1986-04-11 00:00:00.000 | Comedy  | Unknown       |       4842778 |                   11003932 |   1986 |       4 |               2 |             4 |          1985 |
| Ruthless People               | 1986-06-27 00:00:00.000 | Comedy  | R             |      71624879 |                  162748712 |   1986 |       6 |               5 |             4 |          1985 |
| Tough Guys                    | 1986-10-03 00:00:00.000 | Comedy  | Unknown       |      21458229 |                   48758184 |   1986 |      10 |               1 |             4 |          1985 |
| Outrageous Fortune            | 1987-01-30 00:00:00.000 | Comedy  | R             |      52864741 |                  113976921 |   1987 |       1 |               5 |             4 |          1985 |

 


tables: name: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (2)
data: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (2).csv
name: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (3)
data: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (3).csv
name: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (4)
data: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (4).csv
name: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross
data: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross.csv
label: Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross
Genre
Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (3)
Genre
Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (2)
Genre
Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (3)
Genre
Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (4)
Genre
Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (3)
Genre
output: {
    "joins": [
        {
            "from_table": "Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross",
            "from_column": "Genre",
            "to_table": "Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (3)",
            "to_column": "Genre"
        },
        {
            "from_table": "Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (2)",
            "from_column": "Genre",
            "to_table": "Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (3)",
            "to_column": "Genre"
        },
        {
            "from_table": "Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (4)",
            "from_column": "Genre",
            "to_table": "Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (3)",
            "to_column": "Genre"
        }
    ]
}