|< < 48 > >|
Best to think about it algorithmically: for each author a: for each book b: if b.year is between 1960 and 1969 and b.author_id = a.author_id: add a.name to output
for each author a: for each book b: if b.year is between 1960 and 1969 and b.author_id = a.author_id: add a.name to output