帮我写一个sql语句,Which countries are not too small and not too big?BETWEEN allows range checking - note that it is inclusive.e.g:SELECT name,area FROM bbcWHERE area BETWEEN 207600 AND 244820QUESTION:Show the area in 1000 square km.Show area/1

帮我写一个sql语句,Which countries are not too small and not too big?BETWEEN allows range checking - note that it is inclusive.e.g:SELECT name,area FROM bbcWHERE area BETWEEN 207600 AND 244820QUESTION:Show the area in 1000 square km.Show area/1
帮我写一个sql语句,
Which countries are not too small and not too big?
BETWEEN allows range checking - note that it is inclusive.
e.g:
SELECT name,area FROM bbc
WHERE area BETWEEN 207600 AND 244820
QUESTION:
Show the area in 1000 square km.Show area/1000instead of area
就是此页面的最后一个题,验证了答案再发啊.

帮我写一个sql语句,Which countries are not too small and not too big?BETWEEN allows range checking - note that it is inclusive.e.g:SELECT name,area FROM bbcWHERE area BETWEEN 207600 AND 244820QUESTION:Show the area in 1000 square km.Show area/1
如果你Area里面存的是平方米,而查询的时候,使用的是平方公里,则使用以下语句：
SELECT name,area,area/1000 AS area_square_km FROM bbc
WHERE area BETWEEN 207600 AND 244820
如果查询的时候,输入的条件也是平方公里,则使用以下语句：
SELECT name,area,area/1000 AS area_square_km FROM bbc
WHERE area/1000 BETWEEN 207600 AND 244820