Home improvement sales
You're given the following table showing sales information for a home improvement store. The table below shows units sold for each product (specified by product_id) along with each product’s associated category:
Using this table, write a SQL query to return the following:
|...||...||the total sales of the given product||the percent of the total category sales the given product represents...|
You can view/query the table in an interactive SQL fiddle here.
Subscribe to premium account to see the solution.Get premium now