(1) 查询性别为“男”的所有学生的名称并按学号升序排列。SELECT SnameFROM StudentsWHERE Ssex=男ORDER BY Sno(2) 查询学生的选课成绩合格的课程成绩,并把成绩换算为积分。积分的计算公式为:1+(考试成绩-60)*0.1*Ccredit。考试成绩=60 否则=0SELECT Sno, Tno, Reports.Cno, Score, Point of Score, CONVERT(FLOAT(1), (Score-60)*0.1*Ccredit+Ccredit)FROM Courses, ReportsWHERE Score=60 AND Reports.Cno=Courses.CnoUNIONSELECT Sno, Tno, Reports.Cno, Score, Point of Score, 0FROM Courses, ReportsWHERE Reports.Cno=Courses.Cno AND (Score 60 OR Score IS NULL)