Database: book_press
Question: Find 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