select eno,fee from use where fee > 200
select p.pname,u.borrowday,u.fee from use u
inner join person p on u.pno = p.pno
inner join equipment e on u.eno = e.eno
where e.ename = '笔记本'
由于不知道usetime的字段类型及含义，假设字段类型为int，存储的单位是天，默认一个月是30天：
select p.pname,u.eno from use u
inner join person p on u.pno = p.pno
inner join equipment e on u.eno = e.eno
where u.usetime > 30
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024