Завершено

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!

Квалификация: PHP, MySQL, SQL

Показать больше 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

О работодателе:
( 27 отзыв(-а, -ов) ) Capalaba, Australia

ID проекта: #20093443

Поручен:

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 Больше

$10 AUD за 1 день
(13 отзывов(-а))
5.6

21 фрилансеров(-а) в среднем готовы выполнить эту работу за $25

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 за 1 день
(91 отзывов(-а))
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 за 1 день
(83 отзывов(-а))
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 за 1 день
(178 отзывов(-а))
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 Больше

$20 AUD за 1 день
(47 отзывов(-а))
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 за 7 дней(-я)
(142 отзывов(-а))
6.0
phamv4n

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

$20 AUD за 7 дней(-я)
(10 отзывов(-а))
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 Больше

$20 AUD за 7 дней(-я)
(25 отзывов(-а))
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 за 7 дней(-я)
(6 отзывов(-а))
4.1
ihshsl

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

$20 AUD за 1 день
(15 отзывов(-а))
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 Больше

$20 AUD за 1 день
(4 отзывов(-а))
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 Больше

$40 AUD за 7 дней(-я)
(12 отзывов(-а))
3.3
$30 AUD за 1 день
(1 отзыв)
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 Больше

$20 AUD за 1 день
(3 отзывов(-а))
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 Больше

$20 AUD за 7 дней(-я)
(10 отзывов(-а))
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 за 1 день
(3 отзывов(-а))
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 Больше

$30 AUD за 2 дней(-я)
(2 отзывов(-а))
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 Больше

$20 AUD за 2 дней(-я)
(0 отзывов(-а))
0.0
$25 AUD за 1 день
(0 отзывов(-а))
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 Больше

$20 AUD за 2 дней(-я)
(0 отзывов(-а))
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 за 2 дней(-я)
(0 отзывов(-а))
0.0