1.
select distinct Ename
from EMP,WORK
where EMP.E#=WORK.E# and WORK.P# in
(select WORK.P#
from WORK,PROJ,EMP
where WORK.P#=PROJ.P# and EMP.E#=WORK.E# and EMP.Ename='Danny')
2.
select Ename
from EMP
where Ename not in
(select distinct Ename
from EMP,WORK
where EMP.E#=WORK.E# and WORK.P# in
(select WORK.P#
from WORK,PROJ,EMP
where WORK.P#=PROJ.P# and EMP.E#=WORK.E# and EMP.Ename='Danny'))
3.
select P#，count(E#) as counts
from WORK
group by P#
having count(E#)>=10
order by count(E#) desc
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024