This SQL script is to analyze sales and revenue among different categories and products from a simulation dataset of the professional E-Commerce platform. The metrics include Total Sales & Revenue, Top Payers, Top Product, Top Category, etc.
This SQL scrpt is to analyze ratings among different movies and reviewers from a simulation dataset fo the professional streaming video platform. The metrics include Rating Spread, Num of Movies, and Avg of Ratings, etc.