We make the simplifying assumption that half of the population are men. Half of the population are women.
Do a join of the tables EDUCATION and POPULATION to solve this problem.
Round the results so that all results are integers.
And make sure that the column headers are:
Total Number of Women with College Education
Total Number of Men with College Education.
Show the JOIN statement (SQL)
Below is POPULATION and EDUCATION
COUNTRY POPU 1 China 1439323776 2 India 1380004385 331002651 273523615 220892340 3 United States 4 Indonesia 5 Pakistan 6 Brazil 7 Nigeria 8 Bangladesh 9 Russia 212559417 206139589 164689383 145934462 128932753 10 Mexico 11 Japan 12 Ethiopia 13 Philippines 14 Egypt 15 Vietnam 16 DR Congo 17 Turkey 18 Iran 19 Germany 126476461 114963588 109581078 102334404 97338579 89561403 84339067 83992949 83783942 69799978 20 Thailand 67886011 65273511 21 United Kingdom 22 France 23 Italy 24 Tanzania 60461826 59734218 25 South Africa 59308690 COUNTRY WOMEN MEN 1 Australia 51.6 42.5 2 Austria 33.4 44.8 3 Belgium 4 Canada 34.2 36.5 53.2 65.5 5 Chile 25.6 24.6 21.4 6 Colombia 26.1 7 Czech Republic 26.1 8 Denmark 45.9 22.4 34.9 9 Estonia 51.8 30.9 10 Finland 53.5 38.6 40. 35.1 32.5 11 France 12 Germany 13 Greece 14 Hungary 15 Iceland 16 Ireland 17 Israel 27.3 33.6 30.3 30.2 21.6 53.4 37.3 51.0 43.5 55.4 45.0 18 Italy 22.4 16.8 53.9 51.5 19 Japan 20 Korea 47.6 52.3 43.7 27.1 35.5 50.5 21 Latvia 22 Lithuania 23 Luxembourg 24 Mexico 53.4 50.0 17.7 18.9 25 Netherlands 40.8 40.0 COUNTRY POPU 1 China 1439323776 2 India 1380004385 331002651 273523615 220892340 3 United States 4 Indonesia 5 Pakistan 6 Brazil 7 Nigeria 8 Bangladesh 9 Russia 212559417 206139589 164689383 145934462 128932753 10 Mexico 11 Japan 12 Ethiopia 13 Philippines 14 Egypt 15 Vietnam 16 DR Congo 17 Turkey 18 Iran 19 Germany 126476461 114963588 109581078 102334404 97338579 89561403 84339067 83992949 83783942 69799978 20 Thailand 67886011 65273511 21 United Kingdom 22 France 23 Italy 24 Tanzania 60461826 59734218 25 South Africa 59308690 COUNTRY WOMEN MEN 1 Australia 51.6 42.5 2 Austria 33.4 44.8 3 Belgium 4 Canada 34.2 36.5 53.2 65.5 5 Chile 25.6 24.6 21.4 6 Colombia 26.1 7 Czech Republic 26.1 8 Denmark 45.9 22.4 34.9 9 Estonia 51.8 30.9 10 Finland 53.5 38.6 40. 35.1 32.5 11 France 12 Germany 13 Greece 14 Hungary 15 Iceland 16 Ireland 17 Israel 27.3 33.6 30.3 30.2 21.6 53.4 37.3 51.0 43.5 55.4 45.0 18 Italy 22.4 16.8 53.9 51.5 19 Japan 20 Korea 47.6 52.3 43.7 27.1 35.5 50.5 21 Latvia 22 Lithuania 23 Luxembourg 24 Mexico 53.4 50.0 17.7 18.9 25 Netherlands 40.8 40.0
