SQL

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Right im getting wound up as ive come up with several answers or this question but not the one that is meant to be right so if i post this link would someone help me out and tell me where im going wrong, slightly embarrassed as its only the second question, but i need to take a breather before i throw this laptop out of the window.

http://sqlzoo.net/1.htm

That is the link and the question number is 2, cant understand why i get loads of different answers that to me seem to be right, but then they are wrong

Thanks in advance for whoever helps me stop being thick
Ed

 

ARGHhhhhhhhhhhhhhhhhh

I cant believe i was being sooooo stupid

i put this

SELECT name from bbc WHERE population < 200000000

and when that returned a message that it wasnt right i started changing everything else but not wat i needed to change

Thanks for that Sparky

Ed

 

Being pedantic I'd say

Code:

select name, gdp/population as 'GDP' from bbc where population >= 200000000

for 2b

For 2c:

Code:

select name, round(population/1000000, 0) as 'population in millions' from bbc where region = 'Asia';

Harry.