Counting and getting top sold items query!

Ask the community
, ,
1

I need to get the top selled items from my data Base.
I have a DB for purchases:

959×171 17.4 KB

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?

2

When will a Wix API for SQL Server become available? These problems would vanish entirely if such an API were accessible.