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: countries of the world
| Country Name      | Country Code   | REGION               |   Population |   Area (sq. mi.) |   Pop, Density (per sq, mi,) |   Coastline (coast/area ratio) |   Net migration |   Infant mortality (per 1000 births) |   GDP ($ per capita) |   Literacy (%) |   Phones (per 1000) |   Arable (%) |   Other (%) | Climate   |   Birthrate |   Deathrate | Agriculture   | Industry   | Service   |
|:------------------|:---------------|:---------------------|-------------:|-----------------:|-----------------------------:|-------------------------------:|----------------:|-------------------------------------:|---------------------:|---------------:|--------------------:|-------------:|------------:|:----------|------------:|------------:|:--------------|:-----------|:----------|
| Afghanistan       | AFG            | ASIA (EX. NEAR EAST) |     31056997 |           647500 |                        481   |                           0    |        44005    |                               163.07 |                  700 |           36   |             43864   |     41609    |       87.65 | 1         |       46.6  |       20.34 | 0.38          | 0.24       | 0.38      |
| Albania           | ALB            | EASTERN EUROPE       |      3581655 |            28748 |                        124.6 |                       46023    |           -4.93 |                                21.52 |                 4500 |           86.5 |                71.2 |     44095    |       74.49 | 3         |    44150    |    44682    | 0.232         | 0.188      | 0.579     |
| Algeria           | DZA            | NORTHERN AFRICA      |     32930091 |          2381740 |                        138   |                           0.04 |           -0.39 |                                31    |                 6000 |           70   |                78.1 |     44621    |       96.53 | 1         |       17.14 |    22372    | 0.101         | 0.6        | 0.298     |
| American Samoa    | ASM            | OCEANIA              |        57794 |              199 |                       2904   |                          58.29 |          -20.71 |                             46631    |                 8000 |           97   |               259.5 |        10    |       75    | 2         |       22.46 |    46447    |               |            |           |
| Andorra           | AND            | WESTERN EUROPE       |        71201 |              468 |                        152.1 |                           0    |        43988    |                             43955    |                19000 |          100   |               497.2 |     44593    |       97.78 | 3         |    26146    |    45809    |               |            |           |
| Angola            | AGO            | SUB-SAHARAN AFRICA   |     12127071 |          1246700 |                          9.7 |                           0.13 |            0    |                               191.19 |                 1900 |           42   |             44050   |     15008    |       97.35 |           |       45.11 |    43885    | 0.096         | 0.658      | 0.246     |
| Anguilla          | AIA            | LATIN AMER. & CARIB  |        13477 |              102 |                        132.1 |                          59.8  |        28034    |                             43911    |                 8600 |           95   |               460   |         0    |      100    | 2         |       14.17 |    12540    | 0.04          | 0.18       | 0.78      |
| Antigua & Barbuda | ATG            | LATIN AMER. & CARIB  |        69108 |              443 |                        156   |                          34.54 |           -6.15 |                                19.46 |                11000 |           89   |               549.9 |        18.18 |       77.27 | 2         |       16.93 |    13636    | 0.038         | 0.22       | 0.743     |
| Argentina         | ARG            | LATIN AMER. & CARIB  |     39921833 |          2766890 |                         14.4 |                           0.18 |            0.61 |                                15.18 |                11200 |           97.1 |               220.4 |     11658    |       87.21 | 3         |       16.73 |    20271    | 0.095         | 0.358      | 0.547     |
| Armenia           | ARM            | C.W. OF IND. STATES  |      2976372 |            29800 |                         99.9 |                           0    |           -6.47 |                                23.28 |                 3500 |           98.6 |               195.7 |        17.55 |       80.15 | 4         |    44024    |    45139    | 0.239         | 0.343      | 0.418     |


Table: GPD by country and year
| Country Code   |   Year |         GDP |
|:---------------|-------:|------------:|
| ABW            |   2007 | 2.62373e+09 |
| AFG            |   2007 | 9.84384e+09 |
| AGO            |   2007 | 6.04489e+10 |
| ALB            |   2007 | 1.0701e+10  |
| AND            |   2007 | 4.01697e+09 |
| ARB            |   2007 | 1.63757e+12 |
| ARE            |   2007 | 2.57916e+11 |
| ARG            |   2007 | 2.87531e+11 |
| ARM            |   2007 | 9.2063e+09  |
| ASM            |   2007 | 5.2e+08     |


Table: MetaData Country
| Country Code   | Country Name         | Region                     | IncomeGroup         | SpecialNotes   |
|:---------------|:---------------------|:---------------------------|:--------------------|:---------------|
| AGO            | Angola               | Sub-Saharan Africa         | Lower middle income |                |
| ALB            | Albania              | Europe & Central Asia      | Upper middle income |                |
| ARE            | United Arab Emirates | Middle East & North Africa | High income         |                |
| ARM            | Armenia              | Europe & Central Asia      | Lower middle income |                |
| ASM            | American Samoa       | East Asia & Pacific        | Upper middle income |                |
| ATG            | Antigua and Barbuda  | Latin America & Caribbean  | High income         |                |
| AZE            | Azerbaijan           | Europe & Central Asia      | Upper middle income |                |
| BDI            | Burundi              | Sub-Saharan Africa         | Low income          |                |
| BEN            | Benin                | Sub-Saharan Africa         | Low income          |                |
| BFA            | Burkina Faso         | Sub-Saharan Africa         | Low income          |                |


Table: Population by country and year
| Country Code   |   Year |   Population |
|:---------------|-------:|-------------:|
| ABW            |   1991 |        64622 |
| AFG            |   1991 |     12993657 |
| AGO            |   1991 |     12553446 |
| ALB            |   1991 |      3266790 |
| AND            |   1991 |        56671 |
| ARB            |   1991 |    230829868 |
| ARE            |   1991 |      1970026 |
| ARG            |   1991 |     33193918 |
| ARM            |   1991 |      3505251 |
| ASM            |   1991 |        48375 |

 


tables: name: countries of the world
data: countries of the world.csv
name: GPD by country and year
data: GPD by country and year.csv
name: MetaData Country
data: MetaData Country.csv
name: Population by country and year
data: Population by country and year.csv
label: GPD by country and year
Country Code
countries of the world
Country Code
Population by country and year
Country Code
countries of the world
Country Code
MetaData Country
Country Code
countries of the world
Country Code
output: {
    "joins": [
        {
            "from_table": "GPD by country and year",
            "from_column": "Country Code",
            "to_table": "countries of the world",
            "to_column": "Country Code"
        },
        {
            "from_table": "Population by country and year",
            "from_column": "Country Code",
            "to_table": "countries of the world",
            "to_column": "Country Code"
        },
        {
            "from_table": "MetaData Country",
            "from_column": "Country Code",
            "to_table": "countries of the world",
            "to_column": "Country Code"
        }
    ]
}