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.
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.
23 freelancers are bidding on average $110 for this job
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