/world-logstash.sql
Last active Oct 26, 2017
| select | |
| co.Code 'code', | |
| co.name 'name', | |
| co.Continent 'continent', | |
| co.region 'region', | |
| co.SurfaceArea 'surface_area', | |
| co.IndepYear 'year_of_independence', | |
| co.Population 'population', | |
| co.LifeExpectancy 'life_expectancy', | |
| co.GovernmentForm 'government_form', | |
| co.Code2 'iso_code', | |
| capital.ID 'capital_id', | |
| capital.Name 'capital_name', | |
| capital.District 'capital_district', | |
| capital.Population 'capital_population', | |
| ci.Name 'cities_name', | |
| ci.id 'cities_id', | |
| ci.District 'cities_district', | |
| ci.Population 'cities_population', | |
| cl.Language 'languages_language', | |
| cl.IsOfficial 'languages_official', | |
| cl.Percentage 'languages_percentage' | |
| from country co | |
| left outer join city capital ON capital.ID = co.Capital | |
| left outer join city ci ON ci.CountryCode = co.Code | |
| left outer join countrylanguage cl on cl.CountryCode = co.Code |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment