Find Jobs
Hire Freelancers

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

$10-30 AUD

Status
Publicerad nästan fem år sedan

$10-30 AUD

Betalning vid leverans
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

Om projektet

14 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
14 frilansar lägger i genomsnitt anbud på $27 AUD för detta uppdrag
Använd 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 Om 1 dag
5,0 (142 omdömen)
7,2
7,2
Använd 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 Om 1 dag
4,9 (124 omdömen)
7,0
7,0
Använd 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 Om 1 dag
5,0 (296 omdömen)
6,9
6,9
Använd 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 Om 7 dagar
4,8 (164 omdömen)
6,4
6,4
Använd 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 Om 1 dag
4,9 (49 omdömen)
6,1
6,1
Använd 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 Om 1 dag
4,9 (26 omdömen)
5,5
5,5
Använd 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 Om 7 dagar
4,8 (29 omdömen)
5,3
5,3
Använd avatar
i can fix it fast please come to the chat...................................................................................................................................
$20 AUD Om 1 dag
3,7 (21 omdömen)
5,0
5,0
Använd 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 Om 1 dag
5,0 (3 omdömen)
2,0
2,0
Använd 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 Om 2 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för AUSTRALIA
Capalaba, Australia
5,0
29
Verifierad betalningsmetod
Medlem sedan juli 12, 2013

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.