单选题

这里有一张中国高校院士数目信息表（院士姓名，高校所在省区）（只展示了部分数...

Question

这里有一张中国高校院士数目信息表（院士姓名，高校所在省区）（只展示了部分数据，其余大量数据形式相同）
+-----------+---------+
|     name     |province |
+-----------+---------+
| ad        |     GD    |
| ws        |     ZJ    |
| ge        |     FJ    |
| MO        |     SX    |
| wi        |     ZJ    |
+-----------+---------+
查询出哪个省区，出生院士人数最多？

A. select province,count(*) as count from college group by province  limit 1

B. select province,count(*) as count from college group by province order by count desc limit 1

C. select province,count(*) as count from college order by count desc limit 1

D. select province,count(*) as count from college group by province order by count limit 1