Database: book_press
Question: For each press, return its name and the number of books that have sale amount above 1000.
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