从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'注意填写时，以表中的列名为准(注意大小写）

从Student表中筛选出生在1990年-1991年的男学生名单的方法是：SELECT StudentNameFROMStudentWHERE (YEAR(Birth) _________ 1990 __________ 1991) __________ (Sex = '男')注：使用大写字母

从Teacher表中选取所有职称在副教授以上的教师的方法是：（注意是多选，有两种以上方法）

A. SELECT TeachernameFROM TeacherWHERE Profession not in ('教授', '副教授')
B. SELECT TeachernameFROM TeacherWHERE Profession in ('教授', '副教授')
C. SELECT TeachernameFROM TeacherWHERE Profession not in ('讲师', '助教')
D. SELECT TeachernameFROM TeacherWHERE Profession in ('讲师', '助教')