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: Country-Fertility-Rate
| CountryName   | CountryCode   | IndicatorName                            | IndicatorCode   |   Year | FertilityRate   | Redundant-Country-Metadata.CountryName   |
|:--------------|:--------------|:-----------------------------------------|:----------------|-------:|:----------------|:-----------------------------------------|
| Andorra       | AND           | Fertility rate, total (births per woman) | SP.DYN.TFRT.IN  |   1960 |                 | Andorra                                  |
| Andorra       | AND           | Fertility rate, total (births per woman) | SP.DYN.TFRT.IN  |   1961 |                 | Andorra                                  |
| Andorra       | AND           | Fertility rate, total (births per woman) | SP.DYN.TFRT.IN  |   1962 |                 | Andorra                                  |
| Andorra       | AND           | Fertility rate, total (births per woman) | SP.DYN.TFRT.IN  |   1963 |                 | Andorra                                  |
| Andorra       | AND           | Fertility rate, total (births per woman) | SP.DYN.TFRT.IN  |   1964 |                 | Andorra                                  |
| Andorra       | AND           | Fertility rate, total (births per woman) | SP.DYN.TFRT.IN  |   1965 |                 | Andorra                                  |
| Andorra       | AND           | Fertility rate, total (births per woman) | SP.DYN.TFRT.IN  |   1966 |                 | Andorra                                  |
| Andorra       | AND           | Fertility rate, total (births per woman) | SP.DYN.TFRT.IN  |   1967 |                 | Andorra                                  |
| Andorra       | AND           | Fertility rate, total (births per woman) | SP.DYN.TFRT.IN  |   1968 |                 | Andorra                                  |
| Andorra       | AND           | Fertility rate, total (births per woman) | SP.DYN.TFRT.IN  |   1969 |                 | Andorra                                  |


Table: Country-Life-Expectancy-At-Birth
| CountryName          | Country Code   | Indicator Name                          | Indicator Code   |   Year |   LifeExpectancy | Redundant-Country-Metadata.CountryName   |
|:---------------------|:---------------|:----------------------------------------|:-----------------|-------:|-----------------:|:-----------------------------------------|
| Aruba                | ABW            | Life expectancy at birth, total (years) | SP.DYN.LE00.IN   |   2008 |          74.6742 | Aruba                                    |
| Afghanistan          | AFG            | Life expectancy at birth, total (years) | SP.DYN.LE00.IN   |   2008 |          58.6071 | Afghanistan                              |
| Angola               | AGO            | Life expectancy at birth, total (years) | SP.DYN.LE00.IN   |   2008 |          49.8474 | Angola                                   |
| Albania              | ALB            | Life expectancy at birth, total (years) | SP.DYN.LE00.IN   |   2008 |          76.6323 | Albania                                  |
| United Arab Emirates | ARE            | Life expectancy at birth, total (years) | SP.DYN.LE00.IN   |   2008 |          76.2148 | United Arab Emirates                     |
| Argentina            | ARG            | Life expectancy at birth, total (years) | SP.DYN.LE00.IN   |   2008 |          75.3082 | Argentina                                |
| Armenia              | ARM            | Life expectancy at birth, total (years) | SP.DYN.LE00.IN   |   2008 |          73.9439 | Armenia                                  |
| Antigua and Barbuda  | ATG            | Life expectancy at birth, total (years) | SP.DYN.LE00.IN   |   2008 |          74.9869 | Antigua and Barbuda                      |
| Australia            | AUS            | Life expectancy at birth, total (years) | SP.DYN.LE00.IN   |   2008 |          81.3951 | Australia                                |
| Austria              | AUT            | Life expectancy at birth, total (years) | SP.DYN.LE00.IN   |   2008 |          80.4317 | Austria                                  |


Table: Country-Metadata
| CountryName    | CountryCode   | Region                    | IncomeGroup   | SpecialNotes   | ContinentName   | OECD classification   |
|:---------------|:--------------|:--------------------------|:--------------|:---------------|:----------------|:----------------------|
| United Kingdom | GBR           | Europe & Central Asia     | High income   |                | Europe          | OECD                  |
| Switzerland    | CHE           | Europe & Central Asia     | High income   |                | Europe          | OECD                  |
| Chile          | CHL           | Latin America & Caribbean | High income   |                | South America   | OECD                  |
| Denmark        | DNK           | Europe & Central Asia     | High income   |                | Europe          | OECD                  |
| Czech Republic | CZE           | Europe & Central Asia     | High income   |                | Europe          | OECD                  |
| Poland         | POL           | Europe & Central Asia     | High income   |                | Europe          | OECD                  |
| Norway         | NOR           | Europe & Central Asia     | High income   |                | Europe          | OECD                  |
| Iceland        | ISL           | Europe & Central Asia     | High income   |                | Europe          | OECD                  |
| New Caledonia  | NCL           | East Asia & Pacific       | High income   |                | Oceania         | nonOECD               |
| Guam           | GUM           | East Asia & Pacific       | High income   |                | Oceania         | nonOECD               |


Table: Country-Population
| Country Name         | Country Code   | Indicator Name    | Indicator Code   |   Year |   Population | Redundant-Country-Metadata.CountryName   |   !PopulationCC |   !PopulationPercentage | !ParetoPopulation   |
|:---------------------|:---------------|:------------------|:-----------------|-------:|-------------:|:-----------------------------------------|----------------:|------------------------:|:--------------------|
| Aruba                | ABW            | Population, total | SP.POP.TOTL      |   1999 |        89004 | Aruba                                    |          102921 |                0.999847 | C                   |
| Afghanistan          | AFG            | Population, total | SP.POP.TOTL      |   1999 |     19038420 | Afghanistan                              |        30682500 |                0.83397  | B                   |
| Angola               | AGO            | Population, total | SP.POP.TOTL      |   1999 |     14601983 | Angola                                   |        23448202 |                0.876634 | B                   |
| Andorra              | AND            | Population, total | SP.POP.TOTL      |   1999 |        64161 | Andorra                                  |           75902 |                0.999895 | C                   |
| Albania              | ALB            | Population, total | SP.POP.TOTL      |   1999 |      3108778 | Albania                                  |         2897366 |                0.992912 | C                   |
| United Arab Emirates | ARE            | Population, total | SP.POP.TOTL      |   1999 |      2884188 | United Arab Emirates                     |         9039978 |                0.95847  | C                   |
| Argentina            | ARG            | Population, total | SP.POP.TOTL      |   1999 |     36648054 | Argentina                                |        42538304 |                0.794202 | B                   |
| Armenia              | ARM            | Population, total | SP.POP.TOTL      |   1999 |      3093820 | Armenia                                  |         2992192 |                0.992093 | C                   |
| American Samoa       | ASM            | Population, total | SP.POP.TOTL      |   1999 |        56768 | American Samoa                           |           55302 |                0.999937 | C                   |
| Antigua and Barbuda  | ATG            | Population, total | SP.POP.TOTL      |   1999 |        76041 | Antigua and Barbuda                      |           89985 |                0.999859 | C                   |


Table: DimContinents
| ContinentCode   | ContinentName   |
|:----------------|:----------------|
| AF              | Africa          |
| AS              | Asia            |
| EU              | Europe          |
| NA              | North America   |
| SA              | South America   |
| OC              | Oceania         |
| AN              | Antarctica      |


Table: DimCountry
| CountryCode   | ContinentCode   | Name                | iso3   |   Number | FullName                                     |
|:--------------|:----------------|:--------------------|:-------|---------:|:---------------------------------------------|
| AF            | AS              | Afghanistan         | AFG    |        4 | Islamic Republic of Afghanistan              |
| AX            | EU              | Åland Islands       | ALA    |      248 | Åland Islands                                |
| AL            | EU              | Albania             | ALB    |        8 | Republic of Albania                          |
| DZ            | AF              | Algeria             | DZA    |       12 | People's Democratic Republic of Algeria      |
| AS            | OC              | American Samoa      | ASM    |       16 | American Samoa                               |
| AD            | EU              | Andorra             | AND    |       20 | Principality of Andorra                      |
| AO            | AF              | Angola              | AGO    |       24 | Republic of Angola                           |
| AI            | NA              | Anguilla            | AIA    |      660 | Anguilla                                     |
| AQ            | AN              | Antarctica          | ATA    |       10 | Antarctica {the territory South of 60 deg S} |
| AG            | NA              | Antigua and Barbuda | ATG    |       28 | Antigua and Barbuda                          |


Table: DimYear
|   Year | CurrentYear   |
|-------:|:--------------|
|   1960 | No            |
|   1961 | No            |
|   1962 | No            |
|   1963 | No            |
|   1964 | No            |
|   1965 | No            |
|   1966 | No            |
|   1967 | No            |
|   1968 | No            |
|   1969 | No            |


Table: EXAMPLE Invoked Function
| Date                    |   Year |   QuarterOfYear |   MonthOfYear |   DayOfMonth |   DateInt | MonthName   | MonthInCalendar   | QuarterInCalendar   |   DayInWeek | DayOfWeekName   | WeekEnding              |
|:------------------------|-------:|----------------:|--------------:|-------------:|----------:|:------------|:------------------|:--------------------|------------:|:----------------|:------------------------|
| 1960-10-02 00:00:00.000 |   1960 |               4 |            10 |            2 |  19601002 | October     | Oct 1960          | Q4 1960             |           0 | Sunday          | 1960-10-08 00:00:00.000 |
| 1960-10-09 00:00:00.000 |   1960 |               4 |            10 |            9 |  19601009 | October     | Oct 1960          | Q4 1960             |           0 | Sunday          | 1960-10-15 00:00:00.000 |
| 1960-10-16 00:00:00.000 |   1960 |               4 |            10 |           16 |  19601016 | October     | Oct 1960          | Q4 1960             |           0 | Sunday          | 1960-10-22 00:00:00.000 |
| 1960-10-23 00:00:00.000 |   1960 |               4 |            10 |           23 |  19601023 | October     | Oct 1960          | Q4 1960             |           0 | Sunday          | 1960-10-29 00:00:00.000 |
| 1960-10-30 00:00:00.000 |   1960 |               4 |            10 |           30 |  19601030 | October     | Oct 1960          | Q4 1960             |           0 | Sunday          | 1960-11-05 00:00:00.000 |
| 1961-10-01 00:00:00.000 |   1961 |               4 |            10 |            1 |  19611001 | October     | Oct 1961          | Q4 1961             |           0 | Sunday          | 1961-10-07 00:00:00.000 |
| 1961-10-08 00:00:00.000 |   1961 |               4 |            10 |            8 |  19611008 | October     | Oct 1961          | Q4 1961             |           0 | Sunday          | 1961-10-14 00:00:00.000 |
| 1961-10-15 00:00:00.000 |   1961 |               4 |            10 |           15 |  19611015 | October     | Oct 1961          | Q4 1961             |           0 | Sunday          | 1961-10-21 00:00:00.000 |
| 1961-10-22 00:00:00.000 |   1961 |               4 |            10 |           22 |  19611022 | October     | Oct 1961          | Q4 1961             |           0 | Sunday          | 1961-10-28 00:00:00.000 |
| 1961-10-29 00:00:00.000 |   1961 |               4 |            10 |           29 |  19611029 | October     | Oct 1961          | Q4 1961             |           0 | Sunday          | 1961-11-04 00:00:00.000 |

 


tables: name: Country-Fertility-Rate
data: Country-Fertility-Rate.csv
name: Country-Life-Expectancy-At-Birth
data: Country-Life-Expectancy-At-Birth.csv
name: Country-Metadata
data: Country-Metadata.csv
name: Country-Population
data: Country-Population.csv
name: DimContinents
data: DimContinents.csv
name: DimCountry
data: DimCountry.csv
name: DimYear
data: DimYear.csv
name: EXAMPLE Invoked Function
data: EXAMPLE Invoked Function.csv
label: DimCountry
ContinentCode
DimContinents
ContinentCode
DimCountry
CountryCode
Country-Metadata
CountryCode
Country-Fertility-Rate
Year
DimYear
Year
Country-Life-Expectancy-At-Birth
Year
DimYear
Year
Country-Population
Year
DimYear
Year
Country-Population
Country Code
Country-Metadata
CountryCode
Country-Life-Expectancy-At-Birth
Country Code
Country-Metadata
CountryCode
Country-Fertility-Rate
CountryCode
Country-Metadata
CountryCode
output: {
    "joins": [
        {
            "from_table": "DimCountry",
            "from_column": "ContinentCode",
            "to_table": "DimContinents",
            "to_column": "ContinentCode"
        },
        {
            "from_table": "DimCountry",
            "from_column": "CountryCode",
            "to_table": "Country-Metadata",
            "to_column": "CountryCode"
        },
        {
            "from_table": "Country-Fertility-Rate",
            "from_column": "Year",
            "to_table": "DimYear",
            "to_column": "Year"
        },
        {
            "from_table": "Country-Life-Expectancy-At-Birth",
            "from_column": "Year",
            "to_table": "DimYear",
            "to_column": "Year"
        },
        {
            "from_table": "Country-Population",
            "from_column": "Year",
            "to_table": "DimYear",
            "to_column": "Year"
        },
        {
            "from_table": "Country-Population",
            "from_column": "Country Code",
            "to_table": "Country-Metadata",
            "to_column": "CountryCode"
        },
        {
            "from_table": "Country-Life-Expectancy-At-Birth",
            "from_column": "Country Code",
            "to_table": "Country-Metadata",
            "to_column": "CountryCode"
        },
        {
            "from_table": "Country-Fertility-Rate",
            "from_column": "CountryCode",
            "to_table": "Country-Metadata",
            "to_column": "CountryCode"
        }
    ]
}