Skip to Content
0
Former Member
Apr 15, 2014 at 10:56 AM

SQL Query to search for most and least popular brands bought by spesific client and total

406 Views

Hi to SQL query masters!

I need to create a report on most and least popular brand names within one specific client orders.

For example, during last month or a year among 100% of specific client's orders were 70% IBM products, 20% of HP and 10% Lenovo products.

How do I do that?

And I also think that it might be useful to have a query that shows top popular brands among all sales in given period of time – this statistic might improve warehouse turnover and marketing activities on least popular brand names.

I tried to use info from this link, but it didn’t help https://websmp106.sap-ag.de/~form/sapnet?_SCENARIO=01100035870000000183&_FRAME=OBJECT&_HIER_KEY=701100035871000439554&

Kind regards,

Ilya.