求一到基础题。sqlServer多谢

创建语句并填写值 你应该会吧 我给你写一下的sql语句
--sql查询活着的数据
select b.bn,s.sn,Lock.loan,Lock.back from b
left join
(select * from Loan where back is not null and back!='' ) Lock on b.bno=Lock.bon
left join s on Lock.sno=s.sno
where b.bn like '%活着%'

--没有归还数据的学生
select s.sn,s.dept from Loan
left join s on Loan.sno=s.sno
where (Loan.back is null or Loan.back='')