单选题设在SQL Server 2008某数据库中有表SC(Sn0，Cn0，Grade)，其中Grade列的类型为int。若在查询成绩时，希望将成绩按“优”、“良”、“中”、“及格”和“不及格”形式显示，则下列Case函数中正确的是______。

A、 Case GradeWhen Grade between 90 and 100 THEN Grade="优"When Grade between 80 and 89 THEN Grade="良"When Grade between 70 and 79 THEN Grade="由"When Grade between 60 and 69 THEN Grade="及格"Else Grade="不及格"End
B、 Case GradeWhen Grade between 90 and 100 THEN "优"When Grade between 80 and 89 THEN "良"When Grade between 70 and 79 THEN"中"When Grade between 60 and 69 THEN"及格"Else"不及格"End
C、 CaseWhen Grade between 90 and 100 THEN Grade="优"When Grade between 80 and 89 THEN Grade="良"When Grade between 70 and 79 THEN Grade="由"When Grade between 60 and 69 THEN Grade="及格"Else Grade="不及格"End
D、 CaseWhen Grade between 90 and 100 THEN"优"When Grade between 80 and 89 THEN "良"When Grade between 70 and 79 THEN "由"When Grade between 60 and 69 THEN "及格"Else"不及格"End

【正确答案】 D

【答案解析】