Cancelled

MS Mysql - need two querys from a pro

I will provide a retail database from MS MySql. I have an additional document that lists the tables needed for data and how to display. The 1st query is primarily to look up how each product has sold, current inventory and what its anticipated usage might be. the is to determine future purchase based on sales and inventory.

The second is simpler: to query by date and key word a customers purchase history for a future sales offer. For instance, " All customers who purchased chardonnay over $[url removed, login to view] in 2011. Return customer name, email and products purchased in columns".

Please do not apply is you are "handy" with databases. This is the backbone of our operations and requires a skill and comfort zone for this request. We are migrating our online cart and will need to generate 10-15 simpler queries after these two. That will be a private job for whomever this is awarded to. Please do not PM me with your comprehensive skills. My only interest is in how you can accomplish this within our budget and return the data within 3 days with a working query.

To Apply:

You must speak English fluently.

You must complete the job in the allotted time.

This will be paid as a completed job after a working example is provided of each of the two queries.

Please refer to the document for reference.

Thank you for your interest and we look forward to working with you.

Skills: AJAX, MySQL, PHP

See more: retail skills, retail operations, retail job, purchase skills, purchase skill, purchased email lists, online job databases, mysql customer database, job retail, example inventory database, sales operations, operations inventory, migrating, customer job request, backbone, display mysql, need key, php generate word, query php product, need skill, mysql date within days, retail sales online, mysql date days, product display inventory php, ajax return

About the Employer:
( 1 review ) Boston, United States

Project ID: #1100700

23 freelancers are bidding on average $110 for this job

workspaceit

Quality is the main thing that differs us from others. We have experience in this type of works.We are able to do it. Please check PM for details.

$160 USD in 3 days
(42 Reviews)
7.2
aukint

Hey, Greetings from Auk International *****Please check your inbox thanks*****

$150 USD in 3 days
(38 Reviews)
5.6
allroundexperts

I really want more info sir .

$150 USD in 4 days
(111 Reviews)
5.6
lnj2008

i can create complicated queries very well,pls,check pmb

$120 USD in 3 days
(15 Reviews)
5.1
lsowen

Please see PM.

$75 USD in 4 days
(15 Reviews)
5.1
Celoks

Please check PM

$70 USD in 3 days
(13 Reviews)
4.9
freelancerbuzzo

Ready to start right now.

$90 USD in 2 days
(12 Reviews)
4.4
InternetApps

Hi - Love to do the project and hopefully form a long term relationship. I have been dealing with relational databases & SQL for over 30 years so I am more than just "handy". Hope to hear from you. Thanks

$100 USD in 2 days
(1 Review)
4.1
AccuPro

Can do this.

$30 USD in 1 day
(6 Reviews)
3.9
alpust

Ready to work

$100 USD in 5 days
(3 Reviews)
3.0
tgshakthi

Hi, I like to apply for this project, Pls check pmb, Best Regards, TGS

$105 USD in 2 days
(6 Reviews)
3.5
amsak

Pls see PM

$90 USD in 3 days
(7 Reviews)
3.6
bgdn

Hello. I am ready to work on the queries! Please supply all the needed informations and let's start working. Thank you

$65 USD in 2 days
(1 Review)
2.4
ynagaraj

Ready to start

$50 USD in 3 days
(1 Review)
2.6
ajaymalloc

Hi, With 7+ years experience in database design, development, maintenance and admiration for high performing applications, I have extensive knowledge in implementing these solutions and would like to contribute my work More

$120 USD in 2 days
(1 Review)
1.4
shanibkk

i can do this if u wish.thank you

$225 USD in 15 days
(0 Reviews)
0.0
harrisoft1974

Give me a try and you will not need to find another.

$120 USD in 2 days
(0 Reviews)
0.0
nojnish

please refer PMB for details

$240 USD in 4 days
(0 Reviews)
0.0
vuvan02

Please check your PMB

$120 USD in 5 days
(0 Reviews)
0.0
krishanbalram

Work 4 years as a Software Developer. Familiar with Enterprise technologies (Documentum, different Application Servers) and many programming languages. Technical Skills: Documentum ( 2 years ) DC, WebTop, More

$101 USD in 2 days
(0 Reviews)
0.0