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(‘湖南’,‘湖北’);