分析;涉及到Movie、StarsIn表
表结构详见点这里
代码:
select distinct starName
from StarsIn
where movieTitle in(
select title
from Movie
where studioName='st1' and movieYear in(
select year
from Movie
where year='2018'
)
)
嵌套查询!!!