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?