I need to get the top selled items from my data Base.
I have a DB for purchases:
which has all the purchases in my wix store.
What i need is to get the top 3 most sold items!
like if Product A appears 10 times in this dataBase , Product B 8 times and Product C 9 times ,And product D,F,G appreared 5 times each.
i’d like to create a query and run over the DB and check which 3 product appeards the most and bring back those three’s productID (which in the example above will return: ProductA,B,C’s ID.
Can someone help me please how to do this?