Select Code to Download

select book_id from authors
where
...
select book_id from authors
where
  author_name not in ('Smith','Jones');

select book_id from authors
where
...
  )
group by book_id
having count(*)=2