medium10 pts · first answer countswindow-functionssqlrunning-totals

Products making 80% of revenue

You want the smallest set of products that make up 80% of revenue. Which approach works?

A.Keep products whose revenue is above the 80th percentileB.Keep the first 80% of products in alphabetical orderC.Sort by revenue DESC, take a running share of total, keep rows up to 80%D.Use NTILE(5) and keep the first four buckets

Discussion 0

Join free to post in the discussion.

Products making 80% of revenue

Discussion 0

Related questions