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

$10-30 AUD

Inaendelea

Imechapishwa

almost 5 years ago

$10-30 AUD

Kulipwa wakati wa kufikishwa

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

Kitambulisho cha mradi: 20093443

Kuhusu mradi

14 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

14 wafanyakazi huru wana zabuni kwa wastani $27 AUD kwa kazi hii

@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 ndani ya siku 1

5.0

(142 hakiki)

7.2

@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 ndani ya siku 1

4.9

(124 hakiki)

7.0

@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 ndani ya siku 1

5.0

(296 hakiki)

6.9

@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 ndani ya siku 7

4.8

(164 hakiki)

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 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 ndani ya siku 1

4.9

(49 hakiki)

6.1

@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 working right now and hope for your positive response. Regards, Ionel.

$20 AUD ndani ya siku 1

4.9

(26 hakiki)

5.5

@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 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 ndani ya siku 7

4.8

(29 hakiki)

5.3

@ihshsl

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

$20 AUD ndani ya siku 1

3.7

(21 hakiki)

5.0

@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 ndani ya siku 1