SQL Query for Ablecommerce Database - repost



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.

Thank you!

Skills: Database Administration, MySQL, SQL

See more: top query, mysql database free download, download my sql, sql query, query table, 2013 query, looking sql server, orders database, mysql top 100, mysql database orders, login database download, free orders management database, query login database, need sql query, sql server mysql, sql server query, studio sale, database orders, login database query, sql query sql query, top sql, sql database copy, share sale management, phplist database error query error sql syntax, login system sql

Project ID: #5148663

30 freelancers are bidding on average $101 for this job


Hi, I'll be glad to do this work. I'm high rated coder with great experience in the database area includes MS SQL, Sybase, PostgreSQL, MS Access, FoxPro DBs, SQLite etc. Could you please send more detailed spe More

$30 USD in 3 days
(33 Reviews)

Hi, I have 8.5 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have ex More

$35 USD in 3 days
(12 Reviews)

Hi, I'm very interested helping you on your SQL query, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of d More

$34 USD in 1 day
(17 Reviews)

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.

$30 USD in 3 days
(11 Reviews)

A proposal has not yet been provided

$88 USD in 7 days
(4 Reviews)

Being a freelancer in Web Design and development for almost 3 years .My aim is to give my clients the best web applications and websites at reasonable price. I enjoy making great websites that's really creative and More

$20 USD in 1 day
(9 Reviews)

Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Micr More

$30 USD in 3 days
(7 Reviews)

Hello I can start the work on the query immediately and deliver you required result Regards Nikhil

$23 USD in 3 days
(2 Reviews)

I should be able to have this finished today, provided I can get a list of the table columns beforehand to work with. Feel free to message me!

$29 USD in 1 day
(2 Reviews)

Hi, am a web developer with experience in HTML5,CSS3,JavaScript,JQuery,PHP5,Smarty,MySql,Wordpress..., i have already done something similar to your project which can give me the priority to accomplish the job successf More

$35 USD in 0 days
(1 Review)

Hi I have gone through with your requirements and understood the problem. Without wasting in writing a long paragraph, I want to tell you that we are a company having partnership with Microsoft Corporation. We have an More

$27 USD in 1 day
(1 Review)

I have over 5 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like .Net technologies(Asp.Net, Vb.Net / C#.net ) ,PHP, WordPress, SharePoint, VBA, C, C++ More

$23 USD in 3 days
(2 Reviews)

Expert database here. Let me do it right now. Just 1 day for completion. Contact me via skype liemvt90 Regards, Liem

$30 USD in 0 days
(2 Reviews)

A proposal has not yet been provided

$25 USD in 3 days
(0 Reviews)

Having worked on several large, multi-million dollar software projects in high pressure environments both creating and consuming API's, front ends and MSSQL databases, this project should be quite easy for me. I speak More

$25 USD in 3 days
(0 Reviews)

I have large experience in jobs like this one for additional information check my portfolio or use any available contacts to clarify any issue.

$15 USD in 1 day
(0 Reviews)


$25 USD in 2 days
(0 Reviews)

I'm experienced programmer with 13 years of experience with databases and various programming languages. I just started to work from home, apart from my daily job, and I'm eager to prove myself as a programmer.

$35 USD in 5 days
(0 Reviews)

Hi, I am a DB admin for 6+ years. I can do it for you, if you are interest lets to discuss about it. Thanks,

$45 USD in 6 days
(0 Reviews)

Hi, I am new to this website but I have worked with SQL with five years including SQL server and MySQL, I worked with a Retail company which provides technical solution to AU national retailers and my work is purely ba More

$10 USD in 1 day
(0 Reviews)