Database: book_press
Question: Which book series contain both books with sale amount above 1000 and books with sale amount below 500?
SQL:
SELECT book_series FROM book WHERE sale_amount  >  1000 INTERSECT SELECT book_series FROM book WHERE sale_amount  <  500