Database: book_press
Question: Find the book series that have some book selling more than 1000 and some book less 500.
SQL:
SELECT book_series FROM book WHERE sale_amount  >  1000 INTERSECT SELECT book_series FROM book WHERE sale_amount  <  500