SQL Query for Ablecommerce Database

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!

Habilidades: Administração de Bancos de Dados, SQL

Veja mais: top query, download my sql, SQL Query, Sql Database administration, query table, database system sql, SQL Server administration, 2013 query, looking sql server, orders database, login database download, free orders management database, query login database, need sql query, 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, input form query sql database

Acerca do Empregador:
( 150 comentários ) New York, United States

ID do Projeto: #5148503

Concedido a:


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 em 1 dia
(33 Comentários)

7 freelancers are bidding on average $25 for this job


i'm oracle, sql expert. Pls check my porfolio for more details, writing such a complex query is my skill, if you have the link of Ablecommerce, pls let me know sir. I can provide good service, i will definitely not dis Mais

$25 USD em 1 dia
(140 Comentários)

Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 5 years of experience. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://ww Mais

$35 USD in 3 dias
(22 Comentários)

Hi, First of all thanks for posting this project, I am available to provide you economical services for web development , I have read and understood all of project details. I am expert in software development and c Mais

$24 USD in 3 dias
(6 Comentários)

Hi, Dear. I am sql expert. I am interesting with this job. Please contact with me. I can fix that problem in 1 hour. Thank you. Best regards.

$23 USD in 0 dias
(3 Comentários)

I have more 5 years work with sql query. It is very interested. I'm very happy if i could help you on this

$15 USD em 1 dia
(0 Comentários)

A proposal has not yet been provided

$25 USD in 3 dias
(0 Comentários)