ASELECT Sname，Ssex FROM Student WHERE Sdept=（‘湖南’，‘湖北’）；

BSELECT Sanme，Ssex FROM Student WHERE Sdept=’湖南’ORSdept=’湖北’；

CSELECT Sname，Ssex FROM Student WHERE Sdep tLIKE‘湖%’

DSELECT Sname，Ssex FROM Student WHERE Sdept LIKE‘%湖’；

ESELECT Sname，Ssex FROM Student WHERE Sdept IN（‘湖南’，‘湖北’）；