Find Jobs
Hire Freelancers

MySQL ranking based on groups filtered by column value, on two seperate columns, all in the same table

$15-25 USD / hour

Completed
Posted over 2 years ago

$15-25 USD / hour

Have a scoring website that uses a single table, which combines two events and a cumulative total and final rank: 1. Need ranking in "rank" column based on "total" column sorted in ascending order 2. Need ranking in "final rank" column, based on "final total" column sorted in ascending order, since the lowest final total wins. 3. Also need to be able to when 1 of 3 checkboxes are checked, need to be able to insert a letter based on the checkbox. and remove the totals, and places those records at the bottom, after the ranked rows (which is shown as is in my MySQL statement, but I am just unable to do the ranking, and that column replacement together for the single column) attached you will find the MySQL statement.
Project ID: 32723342

About the project

23 proposals
Remote project
Active 2 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
Hi, I’ve carefully checked your requirements and really interested in this job. I’m full stack web developer . I’m offering best quality and highest performance at lowest price. I’m well versed in PHP ,Laravel React/Redux, Angular JS, Node JS, html/css as well as javascript and jquery. I have much experience in MySQL. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details. Thanks
$40 USD in 1 day
5.0 (11 reviews)
3.9
3.9
23 freelancers are bidding on average $21 USD/hour for this job
User Avatar
Hello Dynamic S.,   We have 20 years of strong experience in PHP, MySQL, as a result, we can successfully complete this project.   Please, review our profile here: https://www.freelancer.com/u/tangramua Here detailed information about our company, our portfolio, and the client's recent reviews.   Also, we wanted to personally discuss questions about your project, which helps us to give you the right estimation.   Best regards, Tangram Canada Inc.  
$25 USD in 5 days
4.7 (225 reviews)
8.6
8.6
User Avatar
Can you give sample data in excel or sql file? also can you share the sample out for each point? or lets have a quick call?
$35 USD in 10 days
4.9 (249 reviews)
8.0
8.0
User Avatar
Hi sir, I'm an experienced Web Developer working since 2007 as a PHP & MySQL coder. I can surely help you with your project and have it done in a timely manner, with fair prices and high quality work. But before we start, just let me make some important questions: 1. Do you need modifications to your SQL statement as well? or changes are only for the frontend page? 2. Was your website made with a PHP framework like Laravel or core PHP? 3. Do your web pages use any kind of javascript framework? Also can you please provide me your website URL? (so I can take a look and make a proper bid). Best Regards.
$15 USD in 10 days
4.9 (153 reviews)
6.9
6.9
User Avatar
I've been working for a database designer for 5 years and experienced realtional databases like mysql, oracle, mssql. I am the one who came up with the idea of MongoDB the document oriented database and also have 3 years experience for data entry. I will do your job perfectly Satisfy customer's requirements perfectly is my objective
$20 USD in 40 days
5.0 (8 reviews)
5.8
5.8
User Avatar
Hello. How are you? I have read your description carefully I am a senior developer. So can help you perfect this. If you give me this project I can do within a few hours. I want to discuss more via chat. Thank you!
$25 USD in 40 days
4.8 (11 reviews)
5.9
5.9
User Avatar
Hello there, i've been working with MYSQL for over 8 years. Actually mysql doesn't support rank function but we can demostrate that rank function by specifying variable and plus when checking the previous row. Pls share me more your requirement so we can discuss. Waiting for your response if interested. Thank you!!!
$20 USD in 40 days
5.0 (25 reviews)
5.8
5.8
User Avatar
I can fix your scoring website's table and other functions with high quality on time. I would like to know the details through the chatting box. Thank you.
$20 USD in 40 days
5.0 (6 reviews)
5.4
5.4
User Avatar
Hi There...! Note : I give you 25% off on my all services. So grabs this special limited discount offer. Let’s get to the Project. I came to know that your Looking a developer which have rich knowledge about Sql development .you need expert SQL expert developer for this job . According to your post description, you need the job done very quickly with an affordable budget. Your requirements are fully clear to me and I am applying only because I meet all the requirements that you are looking for. I have been working as a full stack Sql developer for more than 10 years and I know all the ins and outs of Sql development and customization Project should be 100% correct and Complete that will be my first guarantee service in this project. Moreover, I will be available for you for any kind of future edits and customizations. Sometimes my ten years back clients search for me till now only because of my excellent service. I am mostly in love with communication. I like to be in touch with my clients 24/7 so that they can catch me at any time when they need me. I am looking for the clear final requirements docs of your project so that I can start working immediately. 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. Thanks Sohail jamil
$15 USD in 40 days
4.4 (57 reviews)
6.0
6.0
User Avatar
Hello, I am a PHP, Mysql expert. I can get the ranking and update your project related to checkbox. I am very familiar with Sql query, t-sql, trigger and have full experience in php. I can complete your project in a short time. Please reach out to me and get start the work. Hope your kind response. Thank you! Eudis
$20 USD in 40 days
5.0 (4 reviews)
4.3
4.3
User Avatar
Hello, I have read your job description carefully. I am a web developer with 10 years of experience in PHP, MySQL, Javascript, HTML, CSS. Also, I have rich experience in MySQL Query. So I am interested in and I am confident in your project. If you give me a chance, I will provide you with the perfect result. I hope you send me a quick message. Regards. Diana
$25 USD in 40 days
4.9 (4 reviews)
4.5
4.5
User Avatar
Hello Dear Fellow, I would do it. thank you Wram regards
$20 USD in 3 days
2.5 (6 reviews)
3.8
3.8
User Avatar
Innovative and technically-astute software developer with 13+ years of experience in developing full stack applications. I am confident enough to do justice to your task and complete the task timely and fulfill the expectations.
$20 USD in 1 day
3.8 (6 reviews)
2.0
2.0
User Avatar
Hi, It is easy, I can do on time. I work online, where you can track progress of your project. I have 6 years of experience in development(websites, web applications, mobile apps, desktop applications, I/UX), using PHP, WordPress, Java, Python, JavaScript, ReactJs, Bootstrap, I can start now, please come to chat, to discuss more.
$15 USD in 2 days
1.2 (5 reviews)
3.2
3.2

About the client

Flag of UNITED STATES
Birmingham, United States
5.0
2
Payment method verified
Member since Jan 17, 2022

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.