sql

Question

bbc(name, region, area, population, gdp)

select region,count(name) from bbc  group by region having sum(population)>=1e7

显示每个地区以及的该地区国家总人口数不少于１０００万的国家总数．
显示结果有误；请问错在什么地方，谢谢！

---

墨

Answer 1

是不是数字太大了 超过 int32了阿。。。

---

工作突然有点忙 嘿嘿

Answer 2

select region,count(1) as count from bbc where population> 1e7 group by region 

---

知识改变命运，奋斗成就人生!

Answer 3

我刚才运行了一下你的结果，不对；
 谢谢！

---

墨

Answer 4

name 是国家吗?

---

知识改变命运，奋斗成就人生!

Answer 5

SUM聚合函数不能用在条件筛选语句中吧...
SELECT region,COUNT(*) FROM bbc GROUP BY region WHERE population >= 1E7

Answer 6

能打字段的解释贴上来吗

---

知识改变命运，奋斗成就人生!

Answer 7

name为国家的名字

---

墨

Answer 8

把字段解释帖一帖，意思有点混

---

知识改变命运，奋斗成就人生!

Answer 9

先生，我也运行了你的结果，有误！
谢谢！

---

墨

Answer 10

bbc(name, region, area, population, gdp)

select region,count(name) from bbc  group by region having sum(population)>=1e7

显示每个地区以及的该地区国家总人口数不少于１０００万的国家总数．
显示结果有误；请问错在什么地方，谢谢！

如果 region 是地区的话，你这样试试

select distinct region, (select count(1) from bbc where region = a. region and population > 1e7)

from bbc a

---

知识改变命运，奋斗成就人生!

Answer 11

select distinct region, (select count(1) from bbc where region = a. region and population > 1e7) from bbc a

试过没有?

---

知识改变命运，奋斗成就人生!

Answer 12

name,region,area,population,gdp为表bbc的五个字段；
意思分别为：
国家名字，所属地区，国家面积，人口数，国家GDP

---

墨

Answer 13

那就 OK 了, 就是下面的SQL

select distinct region, (select count(1) from bbc where region = a. region and population > 1e7) from bbc a

---

知识改变命运，奋斗成就人生!