Home > database >  Query data what to write
Query data what to write

Time:09-29

Said the

Topic is

Exclusive OR (XOR). Show the countries that are big by area OR big by population but not both. The Show name, population and area.

Australia has a big area but a small population, it should be included.
Indonesia or has a big population but a small area, it should be included.
China has a big population and big area, it should be excluded.
The United Kingdom has a small population and a small area, it should be excluded.

Refer to the answer is that



Want to know is how to write I wrote many wrong thank you

CodePudding user response:

@ 16 February sun wukong, please move this thread to mysql, looking at an eyesore, that man is the last time,

CodePudding user response:

reference 1st floor qq_37170555 response:
@ 16 February sun wukong, trouble moving this thread to mysql, looking at an eyesore, that man is the last time,

Brain damage a domestic quality is low a question asked so unhappy you really are building more than eat cooking oil pool? I make a month to you ye what ye fly is your annual salary

CodePudding user response:

refer to the second floor weixin_41673886 response:
Quote: refer to 1st floor qq_37170555 response:

@ 16 February sun wukong, please move this thread to mysql, looking at an eyesore, that man is the last time,

Brain damage a domestic quality is low a question asked so unhappy you really are building more than eat cooking oil pool? I make a month what is your annual salary you drag ye fly

Yeah, you cow force ah, a month so much money ah, envy me to death, also have low quality, domestic make yourself like a foreigner, aren't you Chinese?
: pass I fart matter whether you are rich or poor, even if you have money, have a purpose, money can do, you are so rich, how also not see you learn to do some charity, you so of, have the money you have life flowers, but you also need not worry, wait for you in the past over there, I burn for you, you slowly,

CodePudding user response:

 
Select the name, population, area from world where (population & gt; XXX xor area> XXX)
  • Related