Database: book_press
Question: Find the number of books that are sold more than 1000 for each publisher. List the press name as well.
SQL:
SELECT count(*) ,  t2.name FROM book AS t1 JOIN press AS t2 ON t1.press_id  =  t2.press_id WHERE sale_amount  >  1000 GROUP BY t2.name