Database: book_press
Question: What are the name and total book sale amount of each press?
SQL:
SELECT sum(t1.sale_amount) ,  t2.name FROM book AS t1 JOIN press AS t2 ON t1.press_id  =  t2.press_id GROUP BY t1.press_id