Completed

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

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!

Skills: PHP, MySQL, SQL

See more: flash php sql highscore, create online reservation system php sql apache, basic php sql page, php sql site, dynamic link php sql database, web development languages html php sql, php script last month, mssql php sql injection, ikariam php sql, php sql sample code, php sql oscommerce, convert static web page dynamic php sql, create login connection php sql, code source sms gateway php sql, sent email php sql, php sql add text gama, php sql scripts vacation rental calendar, want images php sql, php ini file resolve problem customers log create account

About the Employer:
( 27 reviews ) Capalaba, Australia

Project ID: #20093443

Awarded to:

nisharapath

Hello, how are you? I am a creditist and php expert I am very happy to have an opportunity of bidding your project I have carefully read your posting and understood clearly what you want My rich php development experie More

$10 AUD in 1 day
(13 Reviews)
5.6

21 freelancers are bidding on average $25 for this job

polarjin2017

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
(91 Reviews)
6.7
sweetykantha04

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
(83 Reviews)
6.3
nixtech

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
(178 Reviews)
6.4
ludwig333

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 More

$20 AUD in 1 day
(47 Reviews)
6.0
spryox

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
(142 Reviews)
6.0
phamv4n

!!!!!!!!!!!!!!!!!!!!!!!!!!!!MySQL Master!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!MySQL Master!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!MySQL Master!!!!!!!!!!!!!!!!!!!!!!!!!!!!

$20 AUD in 7 days
(10 Reviews)
5.1
bluebear1888

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 li More

$20 AUD in 7 days
(25 Reviews)
4.6
ZiLongZW

Hi. Do you have a problem with PHP and SQL? I'm an expert developer. I can make it work right away. You would not be unsatisfied. I can work from now on. Please ask any question if you have.

$30 AUD in 7 days
(6 Reviews)
4.1
ihshsl

i can fix it fast please come to the chat...................................................................................................................................

$20 AUD in 1 day
(15 Reviews)
5.0
lordzephirot

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 worki More

$20 AUD in 1 day
(4 Reviews)
3.6
webtecnoworld

Hello, After reading this job description, I am convinced that I would be a perfect fit for this role. That is because of - I am a PHP expert who has 12 years of experience with laravel, codeignitor, wordpress/MySQ More

$40 AUD in 7 days
(12 Reviews)
3.3
$30 AUD in 1 day
(1 Review)
3.0
romansokolv708

Dear client! Thank you for your job posting. I have read your description carefully and I am very interested in your project. I have lots of experience like that before. Frankly speak, your project is piece of cake fo More

$20 AUD in 1 day
(3 Reviews)
2.6
sergeyprince

Hello. I have got 8 years of rich experiences in VBA. I can do VBA programming as fast as you want .I am Data Processing , Excel VBA Expert who knows the value of time, very hard working and always delivers the work o More

$20 AUD in 7 days
(10 Reviews)
2.6
dhakalneil

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
(3 Reviews)
2.0
Molotova

Dear sir. How are you? I have gone through the requirement and would like to raise my interest in the same. I am an expert at : PHP, Mysql, Laravel, Codeigniter,JavaScript, jQuery etc. I believe I have most of the skil More

$30 AUD in 2 days
(2 Reviews)
0.8
binaryorbital

Hi, Your “PHP SQL to find customers who are on a six month renewal” post catch my eye and stood out to me because it is extremely similar to the work I’ve provided for many of my other clients. Hope to hear from you s More

$20 AUD in 2 days
(0 Reviews)
0.0
$25 AUD in 1 day
(0 Reviews)
0.0
poojamaurya1421

Hello, I am trusted HTML,CSS,JS,PHP, Wordpress & WooCommerce developer. I can provide it in given time and in less budget. I have been working on such type of projects for 2 years now .Please see the some links for re More

$20 AUD in 2 days
(0 Reviews)
0.0
CredentGroups

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 Reviews)
0.0