Book Sales - Amazon Interview Question - SQL

Calculate the total revenue made per book. Output the book ID and total sales per book. In case there is a book that has never been sold, include it in your output with a value of 0.
Companies appeared in: Amazon
Difficulty: Medium
Ideas: SQL JOINS (LEFT JOIN)
Problem: t.ly/2bt3c

[@krishnayadav-yj6ph]

The best use of data science. Its a big tool to analyse professional activities of any enterprise.

[@krishnayadav-rb2ei]

Very good information about the revenue generated by selling of books on Amazon platform.