分析:涉及到的表为:
MovieExec、Studio表
利用两个嵌套查询
代码如下;
select name
from MovieExec
where networth>any(
select networth
from MovieExec
where name='a1'
)and certID in (
select presCertID
from Studio
)
分析:涉及到的表为:
MovieExec、Studio表
利用两个嵌套查询
代码如下;
select name
from MovieExec
where networth>any(
select networth
from MovieExec
where name='a1'
)and certID in (
select presCertID
from Studio
)