inquires the highest score, the lowest score and the average score in each section: The course ID, course name, highest score, lowest score, average score, pass rate, medium rate, good rate, excellent rate
-Pass for >=60, medium for: 70-80, excellent for: 80-90, excellent for: >=90
CAST (AVG (N.score) as Decimal (18,2)) [Average score],
cast (select COUNT (1) from SC where C # = m.c# and score >=) *100.0/(select COUNT (1) from SC where C # = m.c#) as Decim Al (18,2)) [Pass rate (%)],
cast (select COUNT (1) from SC where C # = m.c# and score >= and score <) *100.0/(select COUNT (1) from SC where C # = m.c#) as decimal (18,2) [Medium rate (%)],
Cast ((select count (1) from SC where C # = m.c# and score >= and score <) *100.0/(select COUNT (1) from SC where C # = M.C # as Decimal (18,2)) [Good rate (%)],
cast (select COUNT (1) from SC where C # = m.c# and score >=) *100.0/(select COUNT (1) from SC where C # = m.c#) as Decim Al (18,2)) [excellent rate (%)]
(select Max (score) from SC where C # = m.c#) [Highest score],
(select min (score) from SC where C # = m.c#) [min.],
(select CAST (AVG (score) as decimal (18,2)) from SC where C # = m.c#) [average points],
cast (select COUNT (1) from SC where C # = m.c# and score >=) *100.0/(select COUNT (1) from SC where C # = m.c#) as Decim Al (18,2)) [Pass rate (%)],
Cast ((select count (1) from SC where C # = m.c# and score >= and score <) *100.0/(select COUNT (1) from SC where C # = M.C #) as Decimal (18,2) [Medium rate (%)],
cast (select COUNT (1) from SC where C # = m.c# and score >=-score <) *100.0/(select COUNT (1) from SC where C # = m.c#) as decimal (18,2) [Good rate (%)],
cast (select COUNT (1) from SC where C # = m.c# and score >=) *100.0/(select COUNT (1) from SC where C # = m.c#) as Decim Al (18,2)) [excellent rate (%)]
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.