|< < 44 > >|

Subqueries

The in operator tests membership in a set

Running the subquery by itself

Data

select author_id from book where year between 1960 and 1969

author_id 10001 10001 10001

|< < 44 > >|