Find Jobs
Hire Freelancers

SQL developer needed for very small project

$30-250 USD

Completed
Posted about 5 years ago

$30-250 USD

Paid on delivery
Hello, I need to create a query that will update a column's values based on data from another column. Here is the plan: There is a table called 'user_points'. It contains a user's ID and a list of points transactions for that user, plus the date that the transaction happened. Some transactions add points and some transactions minus points. E.g. < TABLE #1: user_points > User ID Points Date 100 -40 Jan 21 100 60 Jan 22 105 -20 Jan 13 105 30 Jan 25 I need to update a column in a different table with the total number of points for each user; the second table has only one entry (row) per user, unlike the first table. I think a SUM query could calculate how many points currently exist for each user, and then print that data into a column like this: < TABLE #2: total_points > User ID Total Points 100 20 105 10 The query needs to make sure that the 'user_id' is the same from the first table and the second table, of course, and then paste the correct points total into the second table, in a column called 'total points'. I can provide screenshots of these tables, more detailed information and database access of course.
Project ID: 18622365

About the project

11 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
Dear client. I've read your project description carefully and very interested. You can see my skills and powers. Let's discuss over chat and get started. Waiting for your reply. Regards.
$50 USD in 1 day
4.5 (12 reviews)
3.6
3.6
11 freelancers are bidding on average $106 USD for this job
User Avatar
Hello sir we have 7 years experience in php and mysql we can start your work now please send me message for details we will finish your work asap
$100 USD in 3 days
4.9 (81 reviews)
6.8
6.8
User Avatar
Surely, I've given expertise. I'm Microsoft Certified Professional, Senior Software Engineer and Microsoft Certified Trainer with over five Years of Experience. Skills: ASP.NET Core (MVC 6), MVC 5, WCF, N-Tier Architecture, micro services, Azure, Web Api 2, Angular 2.0, and 4.0, React js, Entity Framework, SQL Server, and Crystal Reporting. I have good command over C#, design patterns, SOLID, KISS, SQL Server, Visual Studio, JSON, Web Services, Knockout js, Signalr js, JQuery, XML,HTML 5, CSS 3., SSRS, SSAS, SSIS, SharePoint, Social APIs like Facebook, twitter and other. Certifications: MCP, MCSD, MCT Work: I have developed a number of .NET web applications like Accounting Application, Marking Application, Institute Affiliation and Registration Application, Financial application, Tourisms web system with social integration logging, push notifications etc. I always complete my commitment and project deadlines. I want to work with you and make our relation strong for a long time. I prove productive and efficient in my work.
$135 USD in 3 days
4.9 (31 reviews)
5.1
5.1
User Avatar
Hello!! I am SQL developer having more then 6 years experience. Skills: Extensive experience in SQL Server Database Design, Database Maintenance, developing SQL queries, stored procedures using SQL Server, Jquery, JavaScript, HTML, AJAX. PM me. Thanks!!
$150 USD in 2 days
5.0 (20 reviews)
5.2
5.2
User Avatar
Hi there, I would like to discuss your work requirements in more details, would you please come on the chat to discuss? Thanks
$155 USD in 3 days
4.9 (13 reviews)
4.4
4.4
User Avatar
Dear client. I've read your project carefully and very interested; I am certified professional in key area and it’s super easy project for me. I can start right away as i always beat deadlines you can check my reviews & ratings. Let's discuss over chat and get started. Waiting for your reply. Thanks
$230 USD in 2 days
5.0 (2 reviews)
2.4
2.4
User Avatar
Hi, I can create one query that updates table "total_points" Summing points from table "user_points " summing points for each user. I am Visual basic & SQL Certified programmer More than 500 VBA, Access database applications delivered successfully I have over 14 years of experience in developing applications using MS Access, SQL, Excel, Excel VBA. I am new to freelancer, but i am top rated in upwork working as full time freelancer from past few years I am trying to make my impression in freelancer also I can do this job Awaiting for response Thanks & Regards, Manjunatha
$30 USD in 1 day
4.6 (1 review)
1.6
1.6
User Avatar
Hi there...i'm ruwan...i'm 5+ years experienced software and database developer...i have many experience in T-Sql queries....i can give you the update query you want....please contact me if you are interested...thank you....
$50 USD in 2 days
0.0 (0 reviews)
1.0
1.0
User Avatar
Hello, I am developer and database developer and maintainer i have more than two years of experience in the field. i will provide you satisfying service. accept my bid to give me a chance to work with you.
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of KOREA, REPUBLIC OF
seoul, Korea, Republic of
5.0
3
Member since Sep 8, 2012

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.