求1个sql语句

njkzkj

如下表
tabl_student:
ID    NAME   SCORE
1     AA          89
2    BB           79
3    CC          99
....
要求用一条SQL语句得到全班>=90的人的百分比，<90 同时>60的百分比，
怎么写呢，注意 全班人数不知道 ，只有跟据count(*) 数出来

ideawu

2. select
3. (select
4.     count(*) / (select count(*) from tabl_student)
5. from tabl_student where SCORE >= 90) as a1,
6. (select
7.     count(*) / (select count(*) from tabl_student)
8. from tabl_student where SCORE < 90 and SCORE > 60) as a2;

复制代码

在5.0下通过.

njkzkj

Greate thanks to you . Passed under 4.1.13-standard ,too.
But can any one give me a more efficient solution.
  ^_^  Greedy