Project Detail

MySQL Database Query Script  

MySQL Database Query Script is project number 450019
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: SoftEngineer

Budget: $30-250

Created: 06/11/2009 at 16:01 EDT

Bid Count: 17

Average Bid:
$ 36

06/12/2009 at 16:01 EDT

Project Creator: oldart
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (6 reviews)

Bid On This Project
 

Description

I am looking for a simple script that will Query my MySQL database and generate a report based on the query. It will basically be querying one table (billing_log).

I need it to find all "amount" paid for each "account" field. Then add them up and give me an average spend amount per user (account). In other words. Each time a users account has been billed by us, an entry goes into the database. So an entry (account) might have have 10 entries in the database. We need to find all these and then add up all their dollar amounts (amount). Once we have this we would like to see the average spend per user. This is what I am after...the average spend per user (account) over the life of of their account.

Things you may need to know:

1. Table has around 10,000 total records
2. Also need to make the query for only those records with the "status" of "A". This is Approved transactions...not Declined.
3. The end result should show three numbers....Total Number of Accounts, Average Number of Transactions per account, and Average Spend per Account.

A demo would be great!

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

30

0 days

06-11-2009 16:21 EDT

hello, please check your PMB.

help

 

30

0 days

06-11-2009 19:42 EDT

VALUEONWEB is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. We have expertise and experience in ecommerce site development, flash and animation. Our team can work on HTML,DHTML, JAVA SCRIPT, FLASH , ASP,ASP.NET,PHP,MY SQL, SQL Server, MS SQL. Our Bid includes development , deployment and testing. We are ready to start and send daily reports. we communicate through email,messenger,phone and skype.We will a deliver a professional looking design(s) with proposed functionality to match your concept.

help

 

30

0 days

06-11-2009 20:14 EDT

Hi, it's hard to build a working demo as I don't have the data. Please see PMB, thanks.

help

 

30

0 days

06-11-2009 16:07 EDT

Hi, I can start right away.. but... can you please send the sql file so i can import it into my database and show you a demo? Thanks Cip

help

 

30

0 days

06-11-2009 19:31 EDT

pretty easy & quick work. ready to start.

help

 

30

0 days

06-11-2009 19:04 EDT

Hi, please check PM for the demo.Thanks

help

 

30

0 days

06-11-2009 16:52 EDT

Hello, I can do this. Please refer PMB. Thanks.

help

 

40

0 days

06-11-2009 16:10 EDT

Please see PM.

help

 

30

0 days

06-11-2009 16:24 EDT

Hello please check pm. Thanks

help

 

30

0 days

06-11-2009 16:49 EDT

Let's start.

help

 

40

0 days

06-11-2009 16:14 EDT

Piece of cake. You'll get pure quality.

help

 

65

4 days

06-11-2009 18:44 EDT

Please provide SQL table structure, and I can have that done for you in no time. - See PM

help

 

30

1 day

06-11-2009 18:06 EDT

see PM for details

help

 

30

1 day

06-11-2009 16:47 EDT

(No Feedback Yet)

Hi, I'm based within an hour of London so fluent English. I can complete this very quickly and very cheap. Hope to hear back.

help

 

75

1 day

06-11-2009 17:25 EDT

(No Feedback Yet)

Hi there, Please check your PMB for more detail. Best regards, Eng. Valentin Secades

help

 

30

0 days

06-11-2009 18:15 EDT

(No Feedback Yet)

Hello. I am a professional MySQL developer. I have expertise in database design, optimisation and OLAP for enterprise projects. I can make a fast query according to MySQL's optimisator mechanism.

help

 

30

1 day

06-11-2009 20:16 EDT

(No Feedback Yet)

Hi, I have posted a demo on your board. Let me know if you would like it implemented. Best Wishes Alastair

help


    Bid on this Project