要找出籍贯是湖北或湖南的学生的姓名和性别,下述SQL语句正确的有哪三项()。
A.SELECT Sname,Ssex FROM Student WHERE Sdept=(‘湖南’,‘湖北’); B.SELECT Sanme,Ssex FROM Student WHERE Sdept=’湖南’ORSdept=’湖北’; C.SELECT Sname,Ssex FROM Student WHERE Sdep tLIKE‘湖%’ D.SELECT Sname,Ssex FROM Student WHERE Sdept LIKE‘%湖’; E.SELECT Sname,Ssex FROM Student WHERE Sdept IN(‘湖南’,‘湖北’);