MYSQL Advance Query $30-250 USD $30-250 USD Paid on delivery
We need a MySQL expert to execute the following query:
We have two tables, one for customer information, and one for the orders placed.
Users table structure (only needed columns): user_id, name, lastname, mail
Sales table structure (only needed columns): sale_id, user_id, sale_total, sale_date, sale_status
What we need is a query that returns name, lastname and mail from the customers that placed their last order within the 2008 or earlier (and never ordered again since then). Also, the order_total must be over "100" and the sale_status must be = "4".
Project ID: 799075
About the project 20 proposals
Remote project
Active 14 yrs ago
Looking to make some money? Email address Apply for similar jobs Benefits of bidding on Freelancer Set your budget and timeframe
It's free to sign up and bid on jobs
20 freelancers are bidding on average $36 USD for this job
Please check the PMB. Ready to start
$30 USD in 1 day
4.9 (266 reviews) this is my job. pm for me. thanks
$100 USD in 0 day
4.8 (238 reviews) I'm mysql expert. Please consider my bid. Thanks, Bo
$30 USD in 0 day
5.0 (337 reviews) $60 USD in 1 day
4.8 (291 reviews) DEAR FRIEND, GET IT DONE NOW. ESCROW REQUIRED. MANY THANKS...
$30 USD in 0 day
4.9 (176 reviews) I could get it done with in a hour lets start right now.
$30 USD in 0 day
4.8 (136 reviews) hi..that pretty easy , please check pm
$30 USD in 0 day
4.9 (64 reviews) I can do it within one hour. Please check PMB.
$40 USD in 0 day
4.8 (53 reviews) $30 USD in 0 day
5.0 (45 reviews) Expert developer. Please read resume and PM.
$30 USD in 1 day
5.0 (8 reviews) Please see PM for details
$30 USD in 0 day
5.0 (2 reviews) please hurry ready,
please check PM
$30 USD in 0 day
0.0 (0 reviews) I will do you query string and check mysql index to provide you a fast return of results. we can talk in espanhol by skype.
$30 USD in 0 day
0.0 (0 reviews) This can be easily done by me.
If you give me a chance than we can go ahead for long.
$40 USD in 2 days
0.0 (0 reviews) Hi, lets start.. please check PM. thanks
$30 USD in 1 day
0.0 (2 reviews) As this is my first project and i dont want to mess it up. This work can be done in no time.
$30 USD in 1 day
0.0 (0 reviews) I have got solution. I hope to give you.
$30 USD in 0 day
0.0 (0 reviews) $30 USD in 1 day
0.0 (0 reviews)