You have chosen to sponsor your bid up to a maximum amount of .
Hello Everyone -
I have Ablecommerce running on a machine and need a SQL query written. I will execute the query in MS SQL Server Management Studio. So, no other code such as C# is needed. Just the SQL query is needed.
The query needs to query the database and display the top 100 customers. The top 100 customers are determined by looking at all the orders in the ac_Orders table and adding up the total sale amount for each ac_User.
You should download and install the free demo copy of Ablecommerce as I do not have the ability to share a login to my copy of the system.