日本黄色一级经典视频|伊人久久精品视频|亚洲黄色色周成人视频九九九|av免费网址黄色小短片|黄色Av无码亚洲成年人|亚洲1区2区3区无码|真人黄片免费观看|无码一级小说欧美日免费三级|日韩中文字幕91在线看|精品久久久无码中文字幕边打电话

當(dāng)前位置:首頁(yè) > 芯聞號(hào) > 充電吧
[導(dǎo)讀]There is a table?World+-----------------+------------+------------+--------------+---------------+ |

There is a table?World

+-----------------+------------+------------+--------------+---------------+
|?name????????????|?continent??|?area???????|?population???|?gdp???????????|
+-----------------+------------+------------+--------------+---------------+
|?Afghanistan?????|?Asia???????|?652230?????|?25500100?????|?20343000??????|
|?Albania?????????|?Europe?????|?28748??????|?2831741??????|?12960000??????|
|?Algeria?????????|?Africa?????|?2381741????|?37100000?????|?188681000?????|
|?Andorra?????????|?Europe?????|?468????????|?78115????????|?3712000???????|
|?Angola??????????|?Africa?????|?1246700????|?20609294?????|?100990000?????|
+-----------------+------------+------------+--------------+---------------+

A country is big if it has an area of bigger than 3 million square km or a population of more than 25 million.

Write a SQL solution to output big countries' name, population and area.

For example, according to the above table, we should output:

+--------------+-------------+--------------+
|?name?????????|?population??|?area?????????|
+--------------+-------------+--------------+
|?Afghanistan??|?25500100????|?652230???????|
|?Algeria??????|?37100000????|?2381741??????|
+--------------+-------------+--------------+
題解:直接寫sql語(yǔ)句即可
select?name,population,area?from?World?where?area>?3000000?or?population>25000000





本站聲明: 本文章由作者或相關(guān)機(jī)構(gòu)授權(quán)發(fā)布,目的在于傳遞更多信息,并不代表本站贊同其觀點(diǎn),本站亦不保證或承諾內(nèi)容真實(shí)性等。需要轉(zhuǎn)載請(qǐng)聯(lián)系該專欄作者,如若文章內(nèi)容侵犯您的權(quán)益,請(qǐng)及時(shí)聯(lián)系本站刪除( 郵箱:macysun@21ic.com )。
換一批
延伸閱讀
關(guān)閉