On this page http://sqlzoo.net/1a.htm there is a question that asks me to show the names of all the countries in Europe that have a GDP per capita that is greater than the UK.
I have so far:
Here’s how to list the countries in Europe
select name from bbc where region = ‘europe’
Here’s how to show the GDP per captia of the UK
select name, gdp/population from bbc where name = ‘united kingdom’
So using these two statements, I tried nesting them together like this:
select name from bbc where gdp/population IN (select name, gdp/population from bbc where region = ‘europe’) >
(select name, gdp/population from bbc where name = ‘united kingdom’)
and the error message I got says: sql: errorOperand should contain 1 column(s)
number: 1241
I can’t seem to properly nest these select queries together and I believe it’s due to an error in my syntax. Can someone show me how to put this together?
Thanks
Alex