Find Jobs
Hire Freelancers

PHP SQL to find customers who are on a six month renewal

$10-30 AUD

In Progress
Posted almost 5 years ago

$10-30 AUD

Paid on delivery
Customers buy from us. purchasedate: YYYY-MM-DD HH:MM:SS renewaldate: YYYY-MM-DD HH:MM:SS Ignoring the day and time. I want to know which customers are renewing at the six month mark; i.e. purchasedate and renewaldate can be divided by six months. So, this month, I need to know people who purchased in December 2018, June 2018, December 2017, June 2017, December 2016, June 2016, etc. Next month I'd need to know people who purchased in January 2019, June 2018 January 2018, June 2017, January 2017, June 2016, January 2016, etc. Thanks!
Project ID: 20093443

About the project

14 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $27 AUD for this job
User Avatar
Hello! I can write a query to get result as per your need. I have very good experience in this. I would be really happy to hear from you. Thanks
$50 AUD in 1 day
5.0 (142 reviews)
7.2
7.2
User Avatar
Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. I have good skills in those. So I think I can help you if you want. Thank you. Best Regards.
$25 AUD in 1 day
4.9 (124 reviews)
7.0
7.0
User Avatar
Hello Sir, I can write queries to display data in 6 month and 1month slot. I am willing to start right away. Please check my profile for work and experience. Regards Ashwin
$35 AUD in 1 day
5.0 (296 reviews)
6.9
6.9
User Avatar
Hi, We can populate a listing where users can be shown whose renewal are on six month. Lets discuss this in detail so i can start the work today itself. Thanks Regards
$30 AUD in 7 days
4.8 (164 reviews)
6.4
6.4
User Avatar
Hello ! I am a full stack developer for over 5 years on the freelancer.com. ⭐⭐Especially sql query expert⭐⭐ I have read your description in more detail and have much interest in your project. I have many experiences what I have ever done before similar to your project. I think that I can finish your work perfectly as you need ASAP. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you very soon. Thank you.
$20 AUD in 1 day
4.9 (49 reviews)
6.1
6.1
User Avatar
Hi, I have read your job description carefully and i am very interested in this job. I am full stack web developer and i am very confident about this job. I will complete this job within a few hours. I can start working right now and hope for your positive response. Regards, Ionel.
$20 AUD in 1 day
4.9 (26 reviews)
5.5
5.5
User Avatar
How do you do? I am a creditist. I'm very happy to have a chance of bidding your project. I have read carefully the descriptions and understood clearly what you want. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a short time. I'm sure I can satisfy for you as you want. Now I'm waiting your answer with mind that I desire you to select me. best regards
$20 AUD in 7 days
4.8 (29 reviews)
5.3
5.3
User Avatar
i can fix it fast please come to the chat...................................................................................................................................
$20 AUD in 1 day
3.7 (21 reviews)
5.0
5.0
User Avatar
Hi, I read you job description and I can do this job very professionally without loosing the quality of work. Please message me so we can discuss more details about the project. Thanks, Neil
$25 AUD in 1 day
5.0 (3 reviews)
2.0
2.0
User Avatar
Hi sir, I am interested to work with you. I am php, mysql expert. I also work on laravel. Please give me the opportunity to work with you.
$20 AUD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Capalaba, Australia
5.0
29
Payment method verified
Member since Jul 12, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.