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.
Hi I have more than 10 years experience in Database administration and SQL query writing. If you want see some of sample work I can supply you. Please see my profile. Thanks.