1.oracle语句 -- 按各科平均成绩从低到高和及格率的百分数从高到低排序 select sc.cid as 课程id,avg(sc.score) as 平均成绩,100*sum(case when sc.score>=60 then 1 else 0 end)/count(1)||'%' as 及格率from scgroup by sc.cidorder by avg(sc.sc
1. 表示分数时,分子须用基数词,分母须用序数词。当分子是1以上的任何数时,分母须用复数形式。1/2: one half 或a half (不读为 one second)1/3: one third 或 a third2/3: two thirds1/4: a quarter 或 one quarter3/4: three quarters 或 three fourths2/5: two fif