Database: book_1
Question: Show the book title and purchase price of the book that has had the greatest amount in orders.
SQL:
SELECT T2.title ,  T2.PurchasePrice FROM Books_Order AS T1 JOIN BOOk AS T2 ON T1.isbn  =  T2.isbn GROUP BY T1.isbn ORDER BY sum(amount) DESC LIMIT 1