列出艺术和计算机科学的平均成绩都在85分或以上的学生?SELECT Students.StudentID, Students.StudFirstName, Students.StudLastName
FROM Students
WHERE EXISTS
(
(SELECT AVG(Student_Schedules.Grade)
FROM Student_Schedules
INNER JOIN Classes
ON Classes.ClassID = Student_Schedules.ClassID
INNER JOIN Subjects
ON Subjects.SubjectID = Classes.SubjectID
INNER JOIN Categories
ON Categories.CategoryID = Subjects.CategoryID
WHERE Categories.CategoryDescription = 'Art'
AND Student_Schedules.StudentID = Students.StudentID) >= 85
)
AND EXISTS
(
(SELECT AVG(Student_Schedules.Grade)
FROM Student_Schedules
INNER JOIN Classes
ON Classes.ClassID = Student_Schedules.ClassID
INNER JOIN Subjects
ON Subjects.SubjectID = Classes.SubjectID
INNER JOIN Categories
ON Categories.CategoryID = Subjects.CategoryID
WHERE Categories.CategoryDescription LIKE '%Computer%'
AND Student_Schedules.StudentID = Students.StudentID) >= 85
)服务器: 消息 170,级别 15,状态 1,行 14
第 14 行: '>' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 27
第 27 行: '>' 附近有语法错误。大家帮我看看这个错误到底是怎么回事?请在您给的答案中讲清楚!!!!谢谢!!!!
FROM Students
WHERE EXISTS
(
(SELECT AVG(Student_Schedules.Grade)
FROM Student_Schedules
INNER JOIN Classes
ON Classes.ClassID = Student_Schedules.ClassID
INNER JOIN Subjects
ON Subjects.SubjectID = Classes.SubjectID
INNER JOIN Categories
ON Categories.CategoryID = Subjects.CategoryID
WHERE Categories.CategoryDescription = 'Art'
AND Student_Schedules.StudentID = Students.StudentID) >= 85
)
AND EXISTS
(
(SELECT AVG(Student_Schedules.Grade)
FROM Student_Schedules
INNER JOIN Classes
ON Classes.ClassID = Student_Schedules.ClassID
INNER JOIN Subjects
ON Subjects.SubjectID = Classes.SubjectID
INNER JOIN Categories
ON Categories.CategoryID = Subjects.CategoryID
WHERE Categories.CategoryDescription LIKE '%Computer%'
AND Student_Schedules.StudentID = Students.StudentID) >= 85
)服务器: 消息 170,级别 15,状态 1,行 14
第 14 行: '>' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 27
第 27 行: '>' 附近有语法错误。大家帮我看看这个错误到底是怎么回事?请在您给的答案中讲清楚!!!!谢谢!!!!
SELECT Students.StudentID, Students.StudFirstName, Students.StudLastName
FROM Students
WHERE
(
(SELECT AVG(Student_Schedules.Grade)
FROM Student_Schedules
INNER JOIN Classes
ON Classes.ClassID = Student_Schedules.ClassID
INNER JOIN Subjects
ON Subjects.SubjectID = Classes.SubjectID
INNER JOIN Categories
ON Categories.CategoryID = Subjects.CategoryID
WHERE Categories.CategoryDescription = 'Art'
AND Student_Schedules.StudentID = Students.StudentID) >= 85
)
AND
(
(SELECT AVG(Student_Schedules.Grade)
FROM Student_Schedules
INNER JOIN Classes
ON Classes.ClassID = Student_Schedules.ClassID
INNER JOIN Subjects
ON Subjects.SubjectID = Classes.SubjectID
INNER JOIN Categories
ON Categories.CategoryID = Subjects.CategoryID
WHERE Categories.CategoryDescription LIKE '%Computer%'
AND Student_Schedules.StudentID = Students.StudentID) >= 85
)
把EXISTS去掉就可以了