答案代碼：

create table staff(

? ? EmpName? Varchar(20)? ? ? not null,

EmpSex Varchar(2)? check(Empsex='男' or Empsex='女') not null ,?

EmpAge Int,

U_address Varchar(50),

Tel Varchar(20),

E_mail Varchar(50),

EmpJoinTime Varchar(50)

)

insert into staff( EmpName,EmpSex,EmpAge,U_address,Tel,E_mail,EmpJoinTime? )?

values( '趙龍','男 ',25,' 湖南省長沙市伍家?guī)X江南苑9棟203號',' 0731-4230123','zl@163.net','2005/10/5')

insert into staff( EmpName,EmpSex,EmpAge,U_address,Tel,E_mail,EmpJoinTime? )?

values( '李云','女',23,'湖南省長沙市東風路東風新村21棟502號','0731-4145268','ly@163.net','2003/7/3')

insert into staff( EmpName,EmpSex,EmpAge,U_address,Tel,E_mail,EmpJoinTime? )?

values(? ? ?'孫一成','男',24,'湖南省株洲市601廠宿舍15棟308號','0732-8342567','syc@163.net','2002/2/11')

insert into staff( EmpName,EmpSex,EmpAge,U_address,Tel,E_mail,EmpJoinTime? )?

values(? ? '林笑','男', 27 ,'湖南省郴洲市人民醫(yī)院20棟301號','0735-2245214','null', '2006/1/5')

insert into staff( EmpName,EmpSex,EmpAge,U_address,Tel,E_mail,EmpJoinTime? )?

values(? ? '衛(wèi)晴','女',23 ,'湖南省長沙市望月湖12棟403號','0731-8325124',' wq@163.net','2007/3/5')

insert into staff( EmpName,EmpSex,EmpAge,U_address,Tel,E_mail,EmpJoinTime? )?

values(? ? ?'張高','男',30 ,'湖南省株洲市601廠宿舍18棟122號','0732-8342143','aee@163.net','2004/2/11')

select * from staff

select? EmpName,Tel,U_address from staff?

select? * from staff where EmpSex='女'

select? EmpName,EmpSex? from? staff where EmpSex='男' and EmpAge>=24 and EmpAge<26

select? EmpName,Tel,U_address? from? staff where EmpSex='女' and U_address like '%長沙市%'?

select Tel,U_address from staff where? EmpName in ('李云','孫一成','林笑');

-- 查詢郴洲和株洲的職員的姓名,性別,年齡

select EmpName,EmpSex,EmpAge from staff where? U_address? like '%郴洲%' or U_address? like '%株洲%';

--查詢家住長沙,年齡在25到28歲之間的男職員的姓名

select EmpName from staff where U_address? like '%長沙%' and (EmpAge between 25 and 28) and EmpSex = '男';

-- 查詢郵件地址為空的職員

select * from staff where E_mail is null;