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: level
| level        |   Count |
|:-------------|--------:|
| Intermediate |    1427 |
| Beginner     |    1198 |
| Mixed        |     326 |
| Advanced     |     145 |


Table: lev_java
| level        |   num_skills |
|:-------------|-------------:|
| Beginner     |          419 |
| Intermediate |          418 |
| Mixed        |          136 |
| Advanced     |           20 |


Table: lev_ml
| level        |   num_skills |
|:-------------|-------------:|
| Intermediate |          472 |
| Beginner     |          351 |
| Mixed        |           83 |
| Advanced     |           72 |


Table: lev_mongo
| level        |   num_skills |
|:-------------|-------------:|
| Beginner     |           61 |
| Intermediate |           48 |
| Mixed        |           27 |
| Advanced     |            1 |


Table: lev_mysql
| level        |   num_skills |
|:-------------|-------------:|
| Intermediate |           29 |
| Beginner     |           26 |
| Mixed        |            4 |
| Advanced     |            1 |


Table: lev_python
| level        |   num_skills |
|:-------------|-------------:|
| Intermediate |          436 |
| Beginner     |          302 |
| Mixed        |           70 |
| Advanced     |           50 |


Table: lev_skills
| level        |   num_skills | skills   |
|:-------------|-------------:|:---------|
| Intermediate |           29 | MySQL    |
| Beginner     |           26 | MySQL    |
| Mixed        |            4 | MySQL    |
| Advanced     |            1 | MySQL    |
| Beginner     |           61 | MongoDB  |
| Intermediate |           48 | MongoDB  |
| Mixed        |           27 | MongoDB  |
| Advanced     |            1 | MongoDB  |
| Beginner     |           39 | Tableau  |
| Intermediate |           24 | Tableau  |


Table: lev_tableau
| level        |   num_skills |
|:-------------|-------------:|
| Beginner     |           39 |
| Intermediate |           24 |
| Mixed        |            6 |
| Advanced     |            1 |


Table: students_level
| level        |   students |
|:-------------|-----------:|
| Beginner     |     750430 |
| Intermediate |     542500 |
| Mixed        |     411182 |
| Advanced     |      30079 |


Table: students_skills
| skills           |   students |
|:-----------------|-----------:|
| mysql            |      29415 |
| mongo            |      46064 |
| tableau          |      32063 |
| python           |     455354 |
| machine_learning |     492275 |
| java             |     679020 |


Table: students_uni
| level                    |   students |
|:-------------------------|-----------:|
| Coursera Project Network |      20869 |
| Google Cloud             |     170889 |
| IBM                      |     177052 |
| DeepLearning.AI          |     157730 |
| University of Michigan   |     218972 |
| LearnQuest               |       4324 |
| Johns Hopkins University |      68633 |
| Duke University          |      67502 |
| Microsoft                |       2403 |


Table: uni_java
| university                       |   num_skills |
|:---------------------------------|-------------:|
| Coursera Project Network         |          238 |
| Google Cloud                     |          132 |
| DeepLearning.AI                  |           38 |
| University of Michigan           |           32 |
| LearnQuest                       |           27 |
| Duke University                  |           24 |
| University of California, Irvine |           23 |
| Johns Hopkins University         |           19 |
| University of Pennsylvania       |           19 |
| IBM                              |           17 |


Table: uni_ml
| university                                 |   num_skills |
|:-------------------------------------------|-------------:|
| Coursera Project Network                   |          236 |
| Google Cloud                               |          106 |
| IBM                                        |           63 |
| DeepLearning.AI                            |           53 |
| Microsoft                                  |           37 |
| Johns Hopkins University                   |           26 |
| University of Michigan                     |           22 |
| University of Illinois at Urbana-Champaign |           22 |
| University of Colorado Boulder             |           20 |
| Duke University                            |           17 |


Table: uni_mongo
| university                          |   num_skills |
|:------------------------------------|-------------:|
| Coursera Project Network            |           19 |
| Fundação Instituto de Administração |            9 |
| University of Michigan              |            9 |
| University of Colorado Boulder      |            7 |
| University of Washington            |            6 |
| Johns Hopkins University            |            5 |
| Arizona State University            |            5 |
| IBM                                 |            5 |
| University of Pennsylvania          |            5 |
| University of London                |            4 |


Table: uni_mysql
| university                              |   num_skills |
|:----------------------------------------|-------------:|
| Coursera Project Network                |           36 |
| Duke University                         |            4 |
| Google Cloud                            |            4 |
| University of Michigan                  |            3 |
| University of Colorado System           |            3 |
| University of California, Davis         |            2 |
| Universidad Nacional Autónoma de México |            2 |
| IBM                                     |            1 |
| Cloudera                                |            1 |
| Microsoft                               |            1 |


Table: uni_python
| university                               |   num_skills |
|:-----------------------------------------|-------------:|
| Coursera Project Network                 |          350 |
| IBM                                      |           91 |
| University of Michigan                   |           55 |
| Google Cloud                             |           42 |
| DeepLearning.AI                          |           31 |
| LearnQuest                               |           22 |
| Codio                                    |           15 |
| Universidad de los Andes                 |           13 |
| École Polytechnique Fédérale de Lausanne |           13 |
| Rice University                          |           12 |


Table: uni_tableau
| university                                 |   num_skills |
|:-------------------------------------------|-------------:|
| Coursera Project Network                   |           30 |
| Google                                     |            7 |
| University of California, Davis            |            6 |
| Università di Napoli Federico II           |            4 |
| Duke University                            |            3 |
| University of California, Irvine           |            3 |
| University of Illinois at Urbana-Champaign |            3 |
| Meta                                       |            3 |
| Universidad Austral                        |            2 |
| Google Cloud                               |            2 |

 


tables: name: level
data: level.csv
name: lev_java
data: lev_java.csv
name: lev_ml
data: lev_ml.csv
name: lev_mongo
data: lev_mongo.csv
name: lev_mysql
data: lev_mysql.csv
name: lev_python
data: lev_python.csv
name: lev_skills
data: lev_skills.csv
name: lev_tableau
data: lev_tableau.csv
name: students_level
data: students_level.csv
name: students_skills
data: students_skills.csv
name: students_uni
data: students_uni.csv
name: uni_java
data: uni_java.csv
name: uni_ml
data: uni_ml.csv
name: uni_mongo
data: uni_mongo.csv
name: uni_mysql
data: uni_mysql.csv
name: uni_python
data: uni_python.csv
name: uni_tableau
data: uni_tableau.csv
label: students_level
level
lev_java
level
students_level
level
lev_ml
level
students_level
level
lev_mysql
level
students_level
level
lev_python
level
students_level
level
lev_tableau
level
students_level
level
lev_mongo
level
uni_mongo
num_skills
lev_mongo
num_skills
lev_skills
level
lev_java
level
lev_skills
skills
students_skills
skills
level
level
lev_java
level
uni_java
university
uni_ml
university
uni_java
university
uni_mysql
university
uni_java
university
uni_python
university
uni_python
university
uni_tableau
university
uni_tableau
university
uni_mongo
university
output: {
    "joins": [
        {
            "from_table": "students_level",
            "from_column": "level",
            "to_table": "lev_java",
            "to_column": "level"
        },
        {
            "from_table": "students_level",
            "from_column": "level",
            "to_table": "lev_ml",
            "to_column": "level"
        },
        {
            "from_table": "students_level",
            "from_column": "level",
            "to_table": "lev_mysql",
            "to_column": "level"
        },
        {
            "from_table": "students_level",
            "from_column": "level",
            "to_table": "lev_python",
            "to_column": "level"
        },
        {
            "from_table": "students_level",
            "from_column": "level",
            "to_table": "lev_tableau",
            "to_column": "level"
        },
        {
            "from_table": "students_level",
            "from_column": "level",
            "to_table": "lev_mongo",
            "to_column": "level"
        },
        {
            "from_table": "uni_mongo",
            "from_column": "num_skills",
            "to_table": "lev_mongo",
            "to_column": "num_skills"
        },
        {
            "from_table": "lev_skills",
            "from_column": "level",
            "to_table": "lev_java",
            "to_column": "level"
        },
        {
            "from_table": "lev_skills",
            "from_column": "skills",
            "to_table": "students_skills",
            "to_column": "skills"
        },
        {
            "from_table": "level",
            "from_column": "level",
            "to_table": "lev_java",
            "to_column": "level"
        },
        {
            "from_table": "uni_java",
            "from_column": "university",
            "to_table": "uni_ml",
            "to_column": "university"
        },
        {
            "from_table": "uni_java",
            "from_column": "university",
            "to_table": "uni_mysql",
            "to_column": "university"
        },
        {
            "from_table": "uni_java",
            "from_column": "university",
            "to_table": "uni_python",
            "to_column": "university"
        },
        {
            "from_table": "uni_python",
            "from_column": "university",
            "to_table": "uni_tableau",
            "to_column": "university"
        },
        {
            "from_table": "uni_tableau",
            "from_column": "university",
            "to_table": "uni_mongo",
            "to_column": "university"
        }
    ]
}