|< < 43 > >|

Subqueries

The in operator tests membership in a set

So the subquery could return multiple values.

Data

Who published books in the 1960s?
select name from author where author_id in ( select author_id from book where year between 1960 and 1969 )

|< < 43 > >|