Käynnissä

MySQL Database Query Script

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!

Taidot: Perl, PHP

Näytä lisää: what is database entry, the simple dollar, simple dollar, n query, check total entries database query, query script mysql, database query animation, demo aspnet page query mysql table, three things in life, script words, simple query, query table, php mysql database, mysql report, mysql query, mysql database , mysql 4, find average numbers, report mysql php database, average php mysql, mysql demo php, billed, numbers database, mysql users, transactions script

About the Employer:
( 15 reviews ) Henderson, United States

Projektin tunnus: #450019

Myönnetty käyttäjälle:

SoftEngineer

Hi, please check PM for the [url removed, login to view]

30 $ USD 0 päivässä
(1 arvostelu)
1.0

15 freelanceria on tarjonnut keskimäärin 37 $ tähän työhön

VALUEONWEB

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 experti Lisää

30 $ USD 0 päivässä
(211 arvostelua)
7.9
dboyzhang

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

30 $ USD 0 päivässä
(254 arvostelua)
7.0
grazianno

hello, please check your PMB.

30 $ USD 0 päivässä
(180 arvostelua)
6.9
wincent

pretty easy & quick work. ready to start.

30 $ USD 0 päivässä
(79 arvostelua)
6.0
utpal4job

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

30 $ USD 0 päivässä
(64 arvostelua)
5.9
ciprianvb

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

30 $ USD 0 päivässä
(70 arvostelua)
5.6
tesfalem

Hello please check pm. Thanks

30 $ USD 0 päivässä
(25 arvostelua)
5.1
ShahidMahmood

Let's start.

30 $ USD 0 päivässä
(27 arvostelua)
5.0
mukapu

Please see PM.

40 $ USD 0 päivässä
(36 arvostelua)
4.9
GhostBear

Piece of cake. You'll get pure quality.

40 $ USD 0 päivässä
(8 arvostelua)
3.5
phpfixer

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

65 $ USD 4 päivässä
(3 arvostelua)
2.5
jskdm

see PM for details

30 $ USD 1 päivässä
(3 arvostelua)
2.3
danthorpe2002

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.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
vsecades

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

75 $ USD 1 päivässä
(0 arvostelua)
0.0
FreestylerBG

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.

30 $ USD 0 päivässä
(1 arvostelu)
0.0
Al24

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

30 $ USD 1 päivässä
(0 arvostelua)
0.0