How do I sum the total of books sold based on title of the book?

Screenshot

select b.ISBN, b.title, a.author_name, b.unit_price, p.quantity from books as b left join purchases as p on b.ISBN = p.book_id left join authors as a on b.author_id = a.id;

https://stackoverflow.com/questions/66756294/how-do-i-sum-the-total-of-books-sold-based-on-title-of-the-book March 23, 2021 at 10:08AM