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: Age Charachteristics Median
| Postal Code   | Topic               | Characteristics                                                            |   Total |   Male |   Female |   Age_Popu |
|:--------------|:--------------------|:---------------------------------------------------------------------------|--------:|-------:|---------:|-----------:|
| H8R           | Age characteristics | Total - Distribution (%) of the population by broad age groups - 100% data |     100 |    100 |      100 |    2991300 |
| H3C           | Age characteristics | Total - Distribution (%) of the population by broad age groups - 100% data |     100 |    100 |      100 |    1087700 |
| H3Z           | Age characteristics | Total - Distribution (%) of the population by broad age groups - 100% data |     100 |    100 |      100 |    1181300 |
| H3Y           | Age characteristics | Total - Distribution (%) of the population by broad age groups - 100% data |     100 |    100 |      100 |     974700 |
| H2P           | Age characteristics | Total - Distribution (%) of the population by broad age groups - 100% data |     100 |    100 |      100 |    1469300 |
| H2R           | Age characteristics | Total - Distribution (%) of the population by broad age groups - 100% data |     100 |    100 |      100 |    2243600 |
| H2E           | Age characteristics | Total - Distribution (%) of the population by broad age groups - 100% data |     100 |    100 |      100 |    2429700 |
| H4E           | Age characteristics | Total - Distribution (%) of the population by broad age groups - 100% data |     100 |    100 |      100 |    3051300 |
| H4H           | Age characteristics | Total - Distribution (%) of the population by broad age groups - 100% data |     100 |    100 |      100 |    1926800 |
| H4G           | Age characteristics | Total - Distribution (%) of the population by broad age groups - 100% data |     100 |    100 |      100 |    2948800 |


Table: Age Characteristics
| Postal Code   | Topic               | Characteristics                                                  | Total   | Male   | Female   | age goup           |
|:--------------|:--------------------|:-----------------------------------------------------------------|:--------|:-------|:---------|:-------------------|
| H4Z           | Age characteristics | Total - Age groups and average age of the population - 100% data |         |        |          |                    |
| H4Z           | Age characteristics | 0 to 14 years                                                    |         |        |          | Age 0 to 14 years  |
| H4Z           | Age characteristics | 0 to 4 years                                                     |         |        |          |                    |
| H4Z           | Age characteristics | 5 to 9 years                                                     |         |        |          |                    |
| H4Z           | Age characteristics | 10 to 14 years                                                   |         |        |          |                    |
| H4Z           | Age characteristics | 15 to 64 years                                                   |         |        |          |                    |
| H4Z           | Age characteristics | 15 to 19 years                                                   |         |        |          | Age 15 to 29 years |
| H4Z           | Age characteristics | 20 to 24 years                                                   |         |        |          | Age 15 to 29 years |
| H4Z           | Age characteristics | 25 to 29 years                                                   |         |        |          | Age 25 to 29 years |
| H4Z           | Age characteristics | 30 to 34 years                                                   |         |        |          | Age 30 to 49 years |


Table: Age_Measures



Table: Calendar
| Date                    |   year | Month   |   Month_Number |   WeeDayNumber | WeekDay   |   WeekNumber | Month/Year   |   monthyearnumber |
|:------------------------|-------:|:--------|---------------:|---------------:|:----------|-------------:|:-------------|------------------:|
| 2015-01-01 00:00:00.000 |   2015 | Jan     |              1 |              5 | Thu       |            1 | Jan/2015     |            201501 |
| 2015-01-02 00:00:00.000 |   2015 | Jan     |              1 |              6 | Fri       |            1 | Jan/2015     |            201501 |
| 2015-01-03 00:00:00.000 |   2015 | Jan     |              1 |              7 | Sat       |            1 | Jan/2015     |            201501 |
| 2015-01-04 00:00:00.000 |   2015 | Jan     |              1 |              1 | Sun       |            2 | Jan/2015     |            201501 |
| 2015-01-05 00:00:00.000 |   2015 | Jan     |              1 |              2 | Mon       |            2 | Jan/2015     |            201501 |
| 2015-01-06 00:00:00.000 |   2015 | Jan     |              1 |              3 | Tue       |            2 | Jan/2015     |            201501 |
| 2015-01-07 00:00:00.000 |   2015 | Jan     |              1 |              4 | Wed       |            2 | Jan/2015     |            201501 |
| 2015-01-08 00:00:00.000 |   2015 | Jan     |              1 |              5 | Thu       |            2 | Jan/2015     |            201501 |
| 2015-01-09 00:00:00.000 |   2015 | Jan     |              1 |              6 | Fri       |            2 | Jan/2015     |            201501 |
| 2015-01-10 00:00:00.000 |   2015 | Jan     |              1 |              7 | Sat       |            2 | Jan/2015     |            201501 |


Table: Cod_Area_Montreal
| POSTAL_CODES   | NEIGHBOURHOOD / LOCALITY   | CITY     |
|:---------------|:---------------------------|:---------|
| H2C            | Ahuntsic Central           | Montreal |
| H2M            | Ahuntsic East              | Montreal |
| H2B            | Ahuntsic North             | Montreal |
| H2N            | Ahuntsic Southeast         | Montreal |
| H3L            | Ahuntsic Southwest         | Montreal |
| H1K            | Anjou East                 | Montreal |
| H1J            | Anjou West                 | Montreal |
| H9W            | Beaconsfield               | Montreal |
| H4J            | Cartierville Central       | Montreal |
| H3M            | Cartierville Northeast     | Montreal |


Table: Continent_Country
| Place               | Region_type   | Continent   |
|:--------------------|:--------------|:------------|
| Americas            | Continent     | Americas    |
| Brazil              | Country       | Americas    |
| Colombia            | Country       | Americas    |
| El Salvador         | Country       | Americas    |
| Guyana              | Country       | Americas    |
| Haiti               | Country       | Americas    |
| Jamaica             | Country       | Americas    |
| Mexico              | Country       | Americas    |
| Peru                | Country       | Americas    |
| Trinidad and Tobago | Country       | Americas    |


Table: Factor_Immigrant
|   Grade |   Factor |
|--------:|---------:|
|       1 |       20 |
|       2 |       40 |
|       3 |       60 |
|       4 |       80 |
|       5 |      100 |


Table: Factor_Infraction
|   Grade |   Factor |
|--------:|---------:|
|       1 |       20 |
|       2 |       40 |
|       3 |       60 |
|       4 |       80 |
|       5 |      100 |


Table: Factor_Price
|   Grade |   Factor |
|--------:|---------:|
|       1 |       20 |
|       2 |       40 |
|       3 |       60 |
|       4 |       80 |
|       5 |      100 |


Table: Factor_SchoolScore
|   Grade |   Factor |
|--------:|---------:|
|       1 |       20 |
|       2 |       40 |
|       3 |       60 |
|       4 |       80 |
|       5 |      100 |


Table: Factor_WalkScore
|   Grade |   Factor |
|--------:|---------:|
|       1 |       20 |
|       2 |       40 |
|       3 |       60 |
|       4 |       80 |
|       5 |      100 |


Table: First Official Language
| Postal Code   | Topic                          | Characteristics                                                                                               | Total   | Male   | Female   | Language           |
|:--------------|:-------------------------------|:--------------------------------------------------------------------------------------------------------------|:--------|:-------|:---------|:-------------------|
| H4Y           | First official language spoken | Total - First official language spoken for the total population excluding institutional residents - 100% data |         |        |          | French And Enlgish |
| H4Y           | First official language spoken | English                                                                                                       |         |        |          | French And Enlgish |
| H4Y           | First official language spoken | French                                                                                                        |         |        |          | French And Enlgish |
| H4Y           | First official language spoken | English and French                                                                                            |         |        |          | French And Enlgish |
| H4Y           | First official language spoken | Neither English nor French                                                                                    |         |        |          | French And Enlgish |
| H4Y           | First official language spoken | Official language minority (number)                                                                           |         |        |          | French And Enlgish |
| H4Y           | First official language spoken | Official language minority (percentage)                                                                       |         |        |          | French And Enlgish |
| H5A           | First official language spoken | Total - First official language spoken for the total population excluding institutional residents - 100% data |         |        |          | French And Enlgish |
| H5A           | First official language spoken | English                                                                                                       |         |        |          | French And Enlgish |
| H5A           | First official language spoken | French                                                                                                        |         |        |          | French And Enlgish |


Table: Immigrant Measure



Table: Immigrants by Place
| Postal Code   | Topic                                 | Region   |   Total |   Male |   Female |
|:--------------|:--------------------------------------|:---------|--------:|-------:|---------:|
| H3C           | Immigrants by selected place of birth | Somalia  |       0 |      0 |        0 |
| H3Z           | Immigrants by selected place of birth | Somalia  |       0 |      0 |        0 |
| H3Y           | Immigrants by selected place of birth | Somalia  |       0 |      0 |        0 |
| H2P           | Immigrants by selected place of birth | Somalia  |       0 |      0 |        0 |
| H2E           | Immigrants by selected place of birth | Somalia  |       0 |      0 |        0 |
| H4H           | Immigrants by selected place of birth | Somalia  |       0 |      0 |        0 |
| H4G           | Immigrants by selected place of birth | Somalia  |       0 |      0 |        0 |
| H9H           | Immigrants by selected place of birth | Somalia  |       0 |      0 |        0 |
| H9K           | Immigrants by selected place of birth | Somalia  |       0 |      0 |        0 |
| H1Z           | Immigrants by selected place of birth | Somalia  |       0 |      0 |        0 |


Table: Immigrants_Regions
| Regions                                                                                               |
|:------------------------------------------------------------------------------------------------------|
| Total - Selected places of birth for the immigrant population in private households - 25% sample data |
| Americas                                                                                              |
| Brazil                                                                                                |
| Colombia                                                                                              |
| El Salvador                                                                                           |
| Guyana                                                                                                |
| Haiti                                                                                                 |
| Jamaica                                                                                               |
| Mexico                                                                                                |
| Peru                                                                                                  |


Table: Income Censu
| Postal Code   | Characteristics                                                                              | Total   | Income Legend   | Average Income by House   | Income by Postal Code   |
|:--------------|:---------------------------------------------------------------------------------------------|:--------|:----------------|:--------------------------|:------------------------|
| H4Z           | Total - Income statistics in 2015 for private households by household size - 100% data       |         |                 |                           |                         |
| H4Z           | Median total income of households in 2015 ($)                                                |         |                 |                           |                         |
| H4Z           | Median after-tax income of households in 2015 ($)                                            |         |                 |                           |                         |
| H4Z           | Total - Income statistics in 2015 for one-person private households - 100% data              |         |                 |                           |                         |
| H4Z           | Median total income of one-person households in 2015 ($)                                     |         |                 |                           |                         |
| H4Z           | Median after-tax income of one-person households in 2015 ($)                                 |         |                 |                           |                         |
| H4Z           | Total - Income statistics in 2015 for two-or-more-person private households - 100% data      |         |                 |                           |                         |
| H4Z           | Median total income of two-or-more-person households in 2015 ($)                             |         |                 |                           |                         |
| H4Z           | Median after-tax income of two-or-more-person households in 2015 ($)                         |         |                 |                           |                         |
| H4Z           | Total - Income statistics in 2015 for private households by household size - 25% sample data |         |                 |                           |                         |


Table: Income Measures



Table: Infractions_Measures
| Column   |
|----------|


Table: interventionscitoyendo
| DATE                    | QUART   |   PDQ | Code_Postal   | POSTAL_CODES   | LONGITUDE   | LATITUDE   | CATEGORIE                        |
|:------------------------|:--------|------:|:--------------|:---------------|:------------|:-----------|:---------------------------------|
| 2016-06-16 00:00:00.000 | soir    |    20 |               |                |             |            | Vol dans / sur véhicule à moteur |
| 2017-09-13 00:00:00.000 | soir    |    20 |               |                |             |            | Vol dans / sur véhicule à moteur |
| 2017-06-05 00:00:00.000 | soir    |    20 |               |                |             |            | Vol dans / sur véhicule à moteur |
| 2015-05-29 00:00:00.000 | soir    |    20 |               |                |             |            | Vol dans / sur véhicule à moteur |
| 2017-09-19 00:00:00.000 | soir    |    20 |               |                |             |            | Vol dans / sur véhicule à moteur |
| 2017-07-21 00:00:00.000 | soir    |    20 |               |                |             |            | Vol dans / sur véhicule à moteur |
| 2016-04-16 00:00:00.000 | soir    |    20 |               |                |             |            | Vol dans / sur véhicule à moteur |
| 2016-07-03 00:00:00.000 | soir    |    20 |               |                |             |            | Vol dans / sur véhicule à moteur |
| 2016-03-11 00:00:00.000 | soir    |    20 |               |                |             |            | Vol dans / sur véhicule à moteur |
| 2016-03-01 00:00:00.000 | soir    |    20 |               |                |             |            | Vol dans / sur véhicule à moteur |


Table: Langage Spoken at Home Measures



Table: Language at Work Measures



Table: Language at Work
| Postal Code   | Topic                            | Characteristics           |   Total |   Male |   Female | Column   | Language Most Spoken at Work   |
|:--------------|:---------------------------------|:--------------------------|--------:|-------:|---------:|:---------|:-------------------------------|
| H3B           | Language used most often at work | Aboriginal languages      |       0 |      0 |        0 |          | French                         |
| H3B           | Language used most often at work | Algonquian languages      |       0 |      0 |        0 |          | French                         |
| H3B           | Language used most often at work | Blackfoot                 |       0 |      0 |        0 |          | French                         |
| H3B           | Language used most often at work | Cree-Montagnais languages |       0 |      0 |        0 |          | French                         |
| H3B           | Language used most often at work | Atikamekw                 |       0 |      0 |        0 |          | French                         |
| H3B           | Language used most often at work | Montagnais (Innu)         |       0 |      0 |        0 |          | French                         |
| H3B           | Language used most often at work | Moose Cree                |       0 |      0 |        0 |          | French                         |
| H3B           | Language used most often at work | Naskapi                   |       0 |      0 |        0 |          | French                         |
| H3B           | Language used most often at work | Northern East Cree        |       0 |      0 |        0 |          | French                         |
| H3B           | Language used most often at work | Plains Cree               |       0 |      0 |        0 |          | French                         |


Table: language Measures



Table: Language Official Knowledge Measures



Table: Language official knowledge
| Postal Code   | Topic                           | Characteristics                                                                                                |   Total |   Male |   Female | Column             | language official most knowledge   |
|:--------------|:--------------------------------|:---------------------------------------------------------------------------------------------------------------|--------:|-------:|---------:|:-------------------|:-----------------------------------|
| H8R           | Knowledge of official languages | Total - Knowledge of official languages for the total population excluding institutional residents - 100% data |   29820 |  14530 |    15295 |                    | English and French                 |
| H8R           | Knowledge of official languages | English only                                                                                                   |    5260 |   2575 |     2685 |                    | English and French                 |
| H8R           | Knowledge of official languages | French only                                                                                                    |    7020 |   3080 |     3945 |                    | English and French                 |
| H8R           | Knowledge of official languages | English and French                                                                                             |   16905 |   8615 |     8295 | English and French | English and French                 |
| H8R           | Knowledge of official languages | Neither English nor French                                                                                     |     635 |    265 |      370 |                    | English and French                 |
| H3C           | Knowledge of official languages | Total - Knowledge of official languages for the total population excluding institutional residents - 100% data |   10635 |   5690 |     4950 |                    | English and French                 |
| H3C           | Knowledge of official languages | English only                                                                                                   |    1440 |    790 |      655 |                    | English and French                 |
| H3C           | Knowledge of official languages | French only                                                                                                    |     885 |    420 |      460 |                    | English and French                 |
| H3C           | Knowledge of official languages | English and French                                                                                             |    8170 |   4410 |     3765 | English and French | English and French                 |
| H3C           | Knowledge of official languages | Neither English nor French                                                                                     |     145 |     70 |       75 |                    | English and French                 |


Table: Language Spoken at Home
| Postal Code   | Topic                              | Characteristics           |   Total |   Male |   Female | Column   | Language Most Spoken at Home   |
|:--------------|:-----------------------------------|:--------------------------|--------:|-------:|---------:|:---------|:-------------------------------|
| H3B           | Language spoken most often at home | Aboriginal languages      |       0 |      0 |        0 |          | French                         |
| H3B           | Language spoken most often at home | Algonquian languages      |       0 |      0 |        0 |          | French                         |
| H3B           | Language spoken most often at home | Blackfoot                 |       0 |      0 |        0 |          | French                         |
| H3B           | Language spoken most often at home | Cree-Montagnais languages |       0 |      0 |        0 |          | French                         |
| H3B           | Language spoken most often at home | Atikamekw                 |       0 |      0 |        0 |          | French                         |
| H3B           | Language spoken most often at home | Montagnais (Innu)         |       0 |      0 |        0 |          | French                         |
| H3B           | Language spoken most often at home | Moose Cree                |       0 |      0 |        0 |          | French                         |
| H3B           | Language spoken most often at home | Naskapi                   |       0 |      0 |        0 |          | French                         |
| H3B           | Language spoken most often at home | Northern East Cree        |       0 |      0 |        0 |          | French                         |
| H3B           | Language spoken most often at home | Plains Cree               |       0 |      0 |        0 |          | French                         |


Table: Language Spoken
| Postal Code   | Topic                            | Characteristics           |   Total |   Male |   Female |
|:--------------|:---------------------------------|:--------------------------|--------:|-------:|---------:|
| H3B           | Language used most often at work | Aboriginal languages      |       0 |      0 |        0 |
| H3B           | Language used most often at work | Algonquian languages      |       0 |      0 |        0 |
| H3B           | Language used most often at work | Blackfoot                 |       0 |      0 |        0 |
| H3B           | Language used most often at work | Cree-Montagnais languages |       0 |      0 |        0 |
| H3B           | Language used most often at work | Atikamekw                 |       0 |      0 |        0 |
| H3B           | Language used most often at work | Montagnais (Innu)         |       0 |      0 |        0 |
| H3B           | Language used most often at work | Moose Cree                |       0 |      0 |        0 |
| H3B           | Language used most often at work | Naskapi                   |       0 |      0 |        0 |
| H3B           | Language used most often at work | Northern East Cree        |       0 |      0 |        0 |
| H3B           | Language used most often at work | Plains Cree               |       0 |      0 |        0 |


Table: Languages
| Topic                              | Characteristics                                                                                                   |
|:-----------------------------------|:------------------------------------------------------------------------------------------------------------------|
| Language spoken most often at home | English and French                                                                                                |
| Language spoken most often at home | English                                                                                                           |
| Language spoken most often at home | French                                                                                                            |
| Language spoken most often at home | Total - Language spoken most often at home for the total population excluding institutional residents - 100% data |
| Language spoken most often at home | Single responses                                                                                                  |
| Language spoken most often at home | Official languages                                                                                                |
| Language spoken most often at home | Non-official languages                                                                                            |
| Language spoken most often at home | Aboriginal languages                                                                                              |
| Language spoken most often at home | Algonquian languages                                                                                              |
| Language spoken most often at home | Blackfoot                                                                                                         |


Table: Montreal KIJIJI Rent
|   Column1 | type        | bedroom   |   bathroom |   size(sqft) | address                                           |   price |     lat |     long | url                                                                                                                          | Postal Code   | Apt type   | ZIP Code   |   Walks Sore | School Score       | Language   |   Walk Score Average |
|----------:|:------------|:----------|-----------:|-------------:|:--------------------------------------------------|--------:|--------:|---------:|:-----------------------------------------------------------------------------------------------------------------------------|:--------------|:-----------|:-----------|-------------:|:-------------------|:-----------|---------------------:|
|         2 | Appartement | 4 1/2     |          1 |            0 | 1445 Ouimet St, Saint-Laurent, QC, H4L 3R2        |    1045 | 45.5187 | -73.6877 | https://www.kijiji.ca/v-appartement-condo/laval-rive-nord/2-bedroom-apartment-for-rent-get-1-month-free/1571153837           | H4L           | 4 1/2      | H4L 3S7    |           64 | 5.2                | French     |              62.2024 |
|         3 | Appartement | 4 1/2     |          1 |            0 | 688 Rue Notre-Dame Ouest, Montreal, QC, H3W 1J4   |    1900 | 45.5001 | -73.5597 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/2-bedroom-condo-griffintown-old-port-2-months-free/1505844409    | H3C           | 4 1/2      | H3C 2P6    |           93 |                    | French     |              41.2797 |
|         4 | Appartement | 4 1/2     |          1 |            0 | 6920-40 De L' Épée, Montreal, QC, H3N 2E1         |     890 | 45.5269 | -73.6208 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/super-4-1-2-de-l-epee-parc-extension/1562064046                  | H3N           | 4 1/2      | H3N 2G7    |           80 |                    | English    |              71.8282 |
|        29 | Appartement | 4 1/2     |          1 |            0 | H1W2Z3, Canada                                    |    1250 | 45.5456 | -73.5542 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/renove-grand-41-2-metro-joliette-prefontaine-il/1582655663       | H1W           | 4 1/2      | H1W 2X4    |           70 | 4.45               | French     |              77.1012 |
|        32 | Appartement | 4 1/2     |          1 |            0 | 6300 Lennox, Montreal, QC, H3S 2N8                |    1450 | 45.5127 | -73.624  | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/41-2-2-bedrooms-chambres-ad-outremont-octobre/1505768287         | H3S           | 4 1/2      | H3S 0A4    |           70 | 8.2333333333333325 | French     |              67.5268 |
|        38 | Appartement | 4 1/2     |          1 |            0 | 5885 Cavendish Boulevard, Montreal, QC, H4W 3H2   |    1525 | 45.4783 | -73.6659 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/loyer-du-1er-mois-gratuit-free-first-months-rent-more/1549173456 | H4W           | 4 1/2      | H4W 3L9    |           70 | 7.92               | English    |              43.2785 |
|        43 | Appartement | 4 1/2     |          1 |            0 | 5002 Rue Sherbrooke Ouest, Westmount, QC, H3Z 1H4 |    1895 | 45.4772 | -73.6053 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/2-ch-1-sdb-westmount-1-895-mo/1563407220                         | H3Z           | 4 1/2      | H3Z 1H3    |           90 | 6.3                | English    |              84.64   |
|        44 | Appartement | 4 1/2     |          1 |            0 | 25 Avenue Vincent-D'Indy, Montréal, QC, H2V 2S8   |    1895 | 45.5109 | -73.6142 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/quartier-dynamique-recemment-renove-outremont/1563407231         | H2V           | 4 1/2      | H2V 2S7    |           51 | 6.177777777777778  | French     |              76.0604 |
|        66 | Appartement | 4 1/2     |          1 |            0 | 2195 Rue le Caron, Montréal, QC H4E 1K7, Canada   |     670 | 45.4623 | -73.5945 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/4-5-grand-dernier-etage-verdun-1-octobre-670/1582441834          | H4E           | 4 1/2      | H4E 1K7    |           67 | 2.2                | French     |              61.2584 |
|        67 | Appartement | 4 1/2     |          1 |            0 | 688 Rue Notre-Dame Ouest, Montreal, QC, H3W 1J4   |    1900 | 45.5001 | -73.5597 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/2-bedroom-condo-griffintown-old-port-2-months-free/1505844409    | H3C           | 4 1/2      | H3C 2P6    |           93 |                    | French     |              41.2797 |


Table: Montreal_Choice-Area
| POSTAL_CODES   |   Rank_Infraction |   Rank_Rent_Price |   Rank_WalkScore |   Rank_SchoolScore |   Rank_Immigrant | First_Language   |   Score |   Score qualy |
|:---------------|------------------:|------------------:|-----------------:|-------------------:|-----------------:|:-----------------|--------:|--------------:|
| H2C            |                53 |                90 |               68 |                 45 |               40 | French           | 2.90196 |      0.911765 |
| H2M            |                51 |                73 |               53 |                  1 |               38 | French           | 2.11765 |      0.872549 |
| H2B            |                69 |                94 |               57 |                  1 |               62 | French           | 2.77451 |      1.28431  |
| H2N            |                78 |                71 |               70 |                  1 |               22 | French           | 2.37255 |      0.980392 |
| H3L            |                50 |                62 |               63 |                  6 |               59 | French           | 2.35294 |      1.06863  |
| H1K            |                27 |                81 |               33 |                 13 |               83 | French           | 2.32353 |      1.07843  |
| H1J            |                49 |                78 |               26 |                  1 |               25 | French           | 1.7549  |      0.72549  |
| H9W            |                85 |                 1 |                9 |                 30 |               37 | English          | 1.58824 |      1.19608  |
| H4J            |                72 |                92 |               36 |                 40 |               80 | French           | 3.13725 |      1.4902   |
| H3M            |                76 |                82 |               38 |                 24 |               68 | French           | 2.82353 |      1.41176  |


Table: Montreal_neighborhood
|   L. NO. | NEIGHBOURHOOD / LOCALITY   | POSTAL CODES   | CITY     |
|---------:|:---------------------------|:---------------|:---------|
|        1 | Ahuntsic Central           | H2C            | Montreal |
|        2 | Ahuntsic East              | H2M            | Montreal |
|        3 | Ahuntsic North             | H2B            | Montreal |
|        4 | Ahuntsic Southeast         | H2N            | Montreal |
|        5 | Ahuntsic Southwest         | H3L            | Montreal |
|        6 | Anjou East                 | H1K            | Montreal |
|        7 | Anjou West                 | H1J            | Montreal |
|       11 | Beaconsfield               | H9W            | Montreal |
|       12 | Cartierville Central       | H4J            | Montreal |
|       13 | Cartierville Northeast     | H3M            | Montreal |


Table: Population_dwellings
| Postal Code   |   Population; 2016 |   Private dwellings occupied by usual residents |   Total private dwellings |
|:--------------|-------------------:|------------------------------------------------:|--------------------------:|
| H1A           |              32516 |                                           13832 |                     14287 |
| H1B           |              20160 |                                            9042 |                      9400 |
| H1C           |              14678 |                                            4685 |                      4734 |
| H1E           |              42420 |                                           16437 |                     16941 |
| H1G           |              48556 |                                           19661 |                     21206 |
| H1H           |              36127 |                                           15448 |                     16746 |
| H1J           |              10308 |                                            4772 |                      4893 |
| H1K           |              34821 |                                           14110 |                     14743 |
| H1L           |              33468 |                                           16096 |                     17255 |
| H1M           |              29359 |                                           13940 |                     14691 |


Table: Population_Measures



Table: Price Range
|   price |
|--------:|
|    1045 |
|    1900 |
|     890 |
|    1250 |
|    1450 |
|    1525 |
|    1895 |
|     670 |
|    1180 |
|     800 |


Table: region immigrant
| Region                                                                                                | Region Type   | Column   |
|:------------------------------------------------------------------------------------------------------|:--------------|:---------|
| Total - Selected places of birth for the immigrant population in private households - 25% sample data | Regions       |          |
| Americas                                                                                              | Continent     | Americas |
| Brazil                                                                                                | Regions       | Americas |
| Colombia                                                                                              | Regions       | Americas |
| El Salvador                                                                                           | Regions       | Americas |
| Guyana                                                                                                | Regions       | Americas |
| Haiti                                                                                                 | Regions       | Americas |
| Jamaica                                                                                               | Regions       | Americas |
| Mexico                                                                                                | Regions       | Americas |
| Peru                                                                                                  | Regions       | Americas |


Table: Rental Price



Table: RentalPricesKijij
|   Column1 | type        | bedroom   |   bathroom |   size(sqft) | address                                           |   price |     lat |     long | url                                                                                                                           | Postal Code   | Apt type   | ZIP Code   |
|----------:|:------------|:----------|-----------:|-------------:|:--------------------------------------------------|--------:|--------:|---------:|:------------------------------------------------------------------------------------------------------------------------------|:--------------|:-----------|:-----------|
|         2 | Appartement | 4 1/2     |          1 |            0 | 1445 Ouimet St, Saint-Laurent, QC, H4L 3R2        |    1045 | 45.5187 | -73.6877 | https://www.kijiji.ca/v-appartement-condo/laval-rive-nord/2-bedroom-apartment-for-rent-get-1-month-free/1571153837            | H4L           | 4 1/2      | H4L 3S7    |
|         3 | Appartement | 4 1/2     |          1 |            0 | 688 Rue Notre-Dame Ouest, Montreal, QC, H3W 1J4   |    1900 | 45.5001 | -73.5597 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/2-bedroom-condo-griffintown-old-port-2-months-free/1505844409     | H3C           | 4 1/2      | H3C 2P6    |
|         4 | Appartement | 4 1/2     |          1 |            0 | 6920-40 De L' Épée, Montreal, QC, H3N 2E1         |     890 | 45.5269 | -73.6208 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/super-4-1-2-de-l-epee-parc-extension/1562064046                   | H3N           | 4 1/2      | H3N 2G7    |
|        24 | Appartement | 4 1/2     |          1 |            0 | Avenue Fouquet, Candiac, QC J5R, Canada           |    1500 | 45.3793 | -73.5253 | https://www.kijiji.ca/v-appartement-condo/longueuil-rive-sud/logement-condo-appartement-avec-garage-double-candiac/1463482133 | J5R           | 4 1/2      | J5R 0T3    |
|        26 | Appartement | 4 1/2     |          1 |            0 | 610 RUE MARTEL, RICHELIEU, QC, J3L 5R6            |     995 | 45.4414 | -73.2455 | https://www.kijiji.ca/v-appartement-condo/longueuil-rive-sud/promotion-4-1-2-a-louer-pres-de-tout/1563740851                  | J3L           | 4 1/2      | J3L 5J8    |
|        29 | Appartement | 4 1/2     |          1 |            0 | H1W2Z3, Canada                                    |    1250 | 45.5456 | -73.5542 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/renove-grand-41-2-metro-joliette-prefontaine-il/1582655663        | H1W           | 4 1/2      | H1W 2X4    |
|        32 | Appartement | 4 1/2     |          1 |            0 | 6300 Lennox, Montreal, QC, H3S 2N8                |    1450 | 45.5127 | -73.624  | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/41-2-2-bedrooms-chambres-ad-outremont-octobre/1505768287          | H3S           | 4 1/2      | H3S 0A4    |
|        38 | Appartement | 4 1/2     |          1 |            0 | 5885 Cavendish Boulevard, Montreal, QC, H4W 3H2   |    1525 | 45.4783 | -73.6659 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/loyer-du-1er-mois-gratuit-free-first-months-rent-more/1549173456  | H4W           | 4 1/2      | H4W 3L9    |
|        43 | Appartement | 4 1/2     |          1 |            0 | 5002 Rue Sherbrooke Ouest, Westmount, QC, H3Z 1H4 |    1895 | 45.4772 | -73.6053 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/2-ch-1-sdb-westmount-1-895-mo/1563407220                          | H3Z           | 4 1/2      | H3Z 1H3    |
|        44 | Appartement | 4 1/2     |          1 |            0 | 25 Avenue Vincent-D'Indy, Montréal, QC, H2V 2S8   |    1895 | 45.5109 | -73.6142 | https://www.kijiji.ca/v-appartement-condo/ville-de-montreal/quartier-dynamique-recemment-renove-outremont/1563407231          | H2V           | 4 1/2      | H2V 2S7    |


Table: School_Measures



Table: secondary_schools_2019
| School Namekeyboard_arrow_down   |   Score 2018 - 19 |   Rank 2018 - 19 | Citykeyboard_arrow_down   | language   | School Type   | Posta Code   | Posta Code Detailed   |     Lat |     Long |
|:---------------------------------|------------------:|-----------------:|:--------------------------|:-----------|:--------------|:-------------|:----------------------|--------:|---------:|
| Ali Ibn Abi Talib                |               8.3 |               49 | Montréal                  | French     | Private       | H4N          | H4N 2T6               | 45.5288 | -73.6525 |
| Amos                             |               4.3 |              405 | Montréal                  | French     | Public        | H2S          | H2S 3C4               | 45.5321 | -73.6091 |
| Antoine-de-Saint-Exupéry         |               5.7 |              263 | Montréal                  | French     | Public        | H1R          | H1R 1P9               | 45.5851 | -73.6016 |
| Arménienne Sourp Hagop           |               7.4 |              102 | Montréal                  | French     | Private       | H4J          | H4J 1N1               | 45.5319 | -73.6965 |
| Beaubois                         |               9.5 |               12 | Montréal                  | French     | Private       | H8Y          | H8Y 3T4               | 45.5075 | -73.7804 |
| Beth Rivkah                      |               8.4 |               40 | Montréal                  | French     | Private       | H3W          | H3W 1C2               | 45.4943 | -73.646  |
| Calixa-Lavallée                  |               4.4 |              397 | Montréal                  | French     | Public        | H1H          | H1H 1P8               | 45.5977 | -73.6371 |
| Cavelier-De LaSalle              |               4.4 |              397 | Montréal                  | French     | Public        | H8R          | H8R 2K2               | 45.4179 | -73.6403 |
| Charlemagne                      |              10   |                1 | Montréal                  | French     | Private       | H9K          | H9K 1G4               | 45.4604 | -73.9184 |
| Chomedey-De-Maisonneuve          |               1.3 |              467 | Montréal                  | French     | Public        | H1V          | H1V 2R2               | 45.5527 | -73.5385 |


Table: Secondary_School_Montreal
| School Namekeyboard_arrow_down   |   Score 2018 - 19 |   Rank 2018 - 19 | Citykeyboard_arrow_down   | language   | School Type   | Posta Code   | Posta Code Detailed   |     Lat |     Long |
|:---------------------------------|------------------:|-----------------:|:--------------------------|:-----------|:--------------|:-------------|:----------------------|--------:|---------:|
| Ali Ibn Abi Talib                |               8.3 |               49 | Montréal                  | French     | Private       | H4N          | H4N 2T6               | 45.5288 | -73.6525 |
| Amos                             |               4.3 |              405 | Montréal                  | French     | Public        | H2S          | H2S 3C4               | 45.5321 | -73.6091 |
| Antoine-de-Saint-Exupéry         |               5.7 |              263 | Montréal                  | French     | Public        | H1R          | H1R 1P9               | 45.5851 | -73.6016 |
| Arménienne Sourp Hagop           |               7.4 |              102 | Montréal                  | French     | Private       | H4J          | H4J 1N1               | 45.5319 | -73.6965 |
| Beaubois                         |               9.5 |               12 | Montréal                  | French     | Private       | H8Y          | H8Y 3T4               | 45.5075 | -73.7804 |
| Beth Rivkah                      |               8.4 |               40 | Montréal                  | French     | Private       | H3W          | H3W 1C2               | 45.4943 | -73.646  |
| Calixa-Lavallée                  |               4.4 |              397 | Montréal                  | French     | Public        | H1H          | H1H 1P8               | 45.5977 | -73.6371 |
| Cavelier-De LaSalle              |               4.4 |              397 | Montréal                  | French     | Public        | H8R          | H8R 2K2               | 45.4179 | -73.6403 |
| Charlemagne                      |              10   |                1 | Montréal                  | French     | Private       | H9K          | H9K 1G4               | 45.4604 | -73.9184 |
| Chomedey-De-Maisonneuve          |               1.3 |              467 | Montréal                  | French     | Public        | H1V          | H1V 2R2               | 45.5527 | -73.5385 |


Table: WalkscoreZipcode
| Postal Code   | ZIP_CIDE   |   Walk_Score |   Score List |
|:--------------|:-----------|-------------:|-------------:|
| H1E           | H1E 0A1    |           50 |           50 |
| H1E           | H1E 0A2    |           44 |           44 |
| H1E           | H1E 0A3    |           24 |           24 |
| H1E           | H1E 0A5    |           28 |           28 |
| H1E           | H1E 0A6    |           32 |           32 |
| H1E           | H1E 0A7    |           21 |           21 |
| H1E           | H1E 0A8    |           25 |           25 |
| H1E           | H1E 0A9    |           28 |           28 |
| H1E           | H1E 0B1    |           23 |           23 |
| H1E           | H1E 0B2    |           50 |           50 |

 


tables: name: Age Charachteristics Median
data: Age Charachteristics Median.csv
name: Age Characteristics
data: Age Characteristics.csv
name: Age_Measures
data: Age_Measures.csv
name: Calendar
data: Calendar.csv
name: Cod_Area_Montreal
data: Cod_Area_Montreal.csv
name: Continent_Country
data: Continent_Country.csv
name: Factor_Immigrant
data: Factor_Immigrant.csv
name: Factor_Infraction
data: Factor_Infraction.csv
name: Factor_Price
data: Factor_Price.csv
name: Factor_SchoolScore
data: Factor_SchoolScore.csv
name: Factor_WalkScore
data: Factor_WalkScore.csv
name: First Official Language
data: First Official Language.csv
name: Immigrant Measure
data: Immigrant Measure.csv
name: Immigrants by Place
data: Immigrants by Place.csv
name: Immigrants_Regions
data: Immigrants_Regions.csv
name: Income Censu
data: Income Censu.csv
name: Income Measures
data: Income Measures.csv
name: Infractions_Measures
data: Infractions_Measures.csv
name: interventionscitoyendo
data: interventionscitoyendo.csv
name: Langage Spoken at Home Measures
data: Langage Spoken at Home Measures.csv
name: Language at Work Measures
data: Language at Work Measures.csv
name: Language at Work
data: Language at Work.csv
name: language Measures
data: language Measures.csv
name: Language Official Knowledge Measures
data: Language Official Knowledge Measures.csv
name: Language official knowledge
data: Language official knowledge.csv
name: Language Spoken at Home
data: Language Spoken at Home.csv
name: Language Spoken
data: Language Spoken.csv
name: Languages
data: Languages.csv
name: Montreal KIJIJI Rent
data: Montreal KIJIJI Rent.csv
name: Montreal_Choice-Area
data: Montreal_Choice-Area.csv
name: Montreal_neighborhood
data: Montreal_neighborhood.csv
name: Population_dwellings
data: Population_dwellings.csv
name: Population_Measures
data: Population_Measures.csv
name: Price Range
data: Price Range.csv
name: region immigrant
data: region immigrant.csv
name: Rental Price
data: Rental Price.csv
name: RentalPricesKijij
data: RentalPricesKijij.csv
name: School_Measures
data: School_Measures.csv
name: secondary_schools_2019
data: secondary_schools_2019.csv
name: Secondary_School_Montreal
data: Secondary_School_Montreal.csv
name: WalkscoreZipcode
data: WalkscoreZipcode.csv
label: Montreal_neighborhood
POSTAL CODES
Cod_Area_Montreal
POSTAL_CODES
secondary_schools_2019
Posta Code
Cod_Area_Montreal
POSTAL_CODES
interventionscitoyendo
POSTAL_CODES
Cod_Area_Montreal
POSTAL_CODES
Population_dwellings
Postal Code
Cod_Area_Montreal
POSTAL_CODES
Age Characteristics
Postal Code
Cod_Area_Montreal
POSTAL_CODES
Immigrants by Place
Postal Code
Cod_Area_Montreal
POSTAL_CODES
Immigrants by Place
Region
Immigrants_Regions
Regions
Language Spoken
Postal Code
Cod_Area_Montreal
POSTAL_CODES
Age Charachteristics Median
Postal Code
Cod_Area_Montreal
POSTAL_CODES
Income Censu
Postal Code
Cod_Area_Montreal
POSTAL_CODES
Language at Work
Postal Code
Cod_Area_Montreal
POSTAL_CODES
Language official knowledge
Postal Code
Cod_Area_Montreal
POSTAL_CODES
Language Spoken at Home
Postal Code
Cod_Area_Montreal
POSTAL_CODES
RentalPricesKijij
Postal Code
Cod_Area_Montreal
POSTAL_CODES
WalkscoreZipcode
Postal Code
Cod_Area_Montreal
POSTAL_CODES
Cod_Area_Montreal
POSTAL_CODES
Montreal_Choice-Area
POSTAL_CODES
output: {
    "joins": [
        {
            "from_table": "Montreal_neighborhood",
            "from_column": "POSTAL CODES",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "secondary_schools_2019",
            "from_column": "Posta Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "interventionscitoyendo",
            "from_column": "POSTAL_CODES",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "Population_dwellings",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "Age Characteristics",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "Immigrants by Place",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "Immigrants by Place",
            "from_column": "Region",
            "to_table": "Immigrants_Regions",
            "to_column": "Regions"
        },
        {
            "from_table": "Language Spoken",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "Age Charachteristics Median",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "Income Censu",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "Language at Work",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "Language official knowledge",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "Language Spoken at Home",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "RentalPricesKijij",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "WalkscoreZipcode",
            "from_column": "Postal Code",
            "to_table": "Cod_Area_Montreal",
            "to_column": "POSTAL_CODES"
        },
        {
            "from_table": "Cod_Area_Montreal",
            "from_column": "POSTAL_CODES",
            "to_table": "Montreal_Choice-Area",
            "to_column": "POSTAL_CODES"
        }
    ]
}