从student表中查询1990年出生的女生名字的语句正确的是:
A. SELECT StudentName FROM Student
B. SELECT StudentName FROM Student WHERE Sex = '女'
C. SELECT StudentName FROM Student WHERE Birth = 1990 and Sex = '女'
D. SELECT StudentName FROM Student WHERE YEAR(Birth) = 1990 and Sex = '女'
从Grade表中查询及格的学生的学号、课程ID和分数的方法是:
A. SELECT StudentID, CourseID, Grade FROM Grade WHERE Grade = 60
B. SELECT StudentID, CourseID, Grade FROM Grade WHERE Grade > 60
C. SELECT StudentID, CourseID, Grade FROM Grade WHERE Grade >= 60
D. SELECT StudentID, CourseID, Grade FROM Grade WHERE Grade == 60
从教师表中查询年龄大于等于50的女教师的名字 ,或者年龄大于等于60的男教师的名字的方法是?
A. SELECT Teachername FROM Teacher WHERE (Sex='女' or 2021-YEAR(Brith)>=50) and (Sex='男' or 2021-YEAR(Brith)>=60)
B. SELECT Teachername FROM Teacher WHERE (Sex='女' and 2021-YEAR(Brith)>=50) or (Sex='男' and 2021-YEAR(Brith)>=60)
C. SELECT Teachername FROM Teacher WHERE (Sex='女' and 2021-YEAR(Brith)>=50) and (Sex='男' and 2021-YEAR(Brith)>=60)
D. SELECT Teachername FROM Teacher WHERE (Sex='女' or 2021-YEAR(Brith)>=50) or (Sex='男' or 2021-YEAR(Brith)>=60)
从Class表中选取所有属于系别'Dp01'的班级名称和人数的方法是SELECT ____________,________________FROM ___________WHERE ____________= 'Dp01'注意填写时,以表中的列名为准(注意大小写)