Find Jobs
Hire Freelancers

Write a complex SQL request

$10-30 CAD

Completed
Posted about 5 years ago

$10-30 CAD

Paid on delivery
I need help with an SQL request. In practice it is only to count the number of references of a person if the referenced persons referenced 500 people or more. In pseudo code what I want to do: SELECT * FROM users WHERE referrer_id ='$referral_code' AS user if((SELECT COUNT(*) FROM referrals where id=user) >= 500)
Project ID: 18557832

About the project

8 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
Awarded to:
User Avatar
Hello, I have read you are looking for some help regarding database query, please let me know how I can help you with it, feel free to discuss anything, Hopefully you will get what you want, Thank You
$10 CAD in 1 day
5.0 (5 reviews)
2.7
2.7
8 freelancers are bidding on average $24 CAD for this job
User Avatar
Hi, creating this query is not that complicated, if you like please write me the column names here and i will try to help immediately. Basically you need a single SQL query with a subquery inside, really close to what you have as pseudo code. Thanks, Milan
$15 CAD in 0 day
5.0 (14 reviews)
3.4
3.4
User Avatar
i will help you with any sql statement. I have experience in complex sql queries. feel free to contact me on this.
$20 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm a well experienced sql writer this is very easy for me
$20 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Thank you for posting the project. I believe I will be the right fit for the role as I have done similar projects in the past. Look forward to hearing from you.
$15 CAD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Québec, Canada
5.0
1
Payment method verified
Member since Aug 11, 2016

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.