Finalizat

SQL Sorting assistance required

As an example, I use a simple select statement to return how many times a team has played on a rink. The available rinks in my example are 4, 5 and 6. I have attached a snapshot of the table rows returned.

select

Team, RinkNum, max(PlayedOnRink) as RinkUsedNum

from

Algorithms_RinkUsage

where

RinkNum = 4 or RinkNum = 5 or RinkNum = 6

group by

Team, RinkNum

order by

RinkUsedNum desc

I also have the next match array and in this example, it is DCAEBF. I split into these 3 matches:

D v C

A v E

B v F

and I need to assign each match the best rinks to use and that is the rinks they have played on the least. It is important in bowls that teams don't keep playing on the same rink and usage for teams is distributed as evenly as possible.

I need to somehow take into account the table rows returned - for example, it shows Team A has played on Rink 4 twice already so shouldn't be assigned that rink, Team F has played on Rink 5 twice so shouldn't be assigned that rink.

The best result would be D v C is assigned Rink 4, A v E is assigned Rink 5 and B v F assigned Rink 6.

I don't know how much to offer for this project because I don't know what's involved so I've set it as a micro project £20.00 but will pay more if necessary. Thanks for looking.

Aptitudini: SQL

Vezi mai multe: assistance required, virtual assistance required, assistance required full time, how will i get my prettiest daughter on advertising às soon as possible, that i need surgery as soon as possible translated in spanish, as soon as possible in french, Project for mlvp24, Payroll assistant needed as soon as possible Kindly text me back to my cell 5024961114 for more information , Assistance required to setup Ecommerce Backend, SAS assistance required, Analyse data, Assistance required with Magento multi-site, You are given n numbers in an array A. Describe an efficient parallel algorithm for sorting the numbers in the array A using p p, You are given n numbers in an array A. Describe an efficient parallel algorithm for sorting the numbers in the array A using p , customise a website as fast as possible, as soon as possible, I have a PDF file of an autocad drawing, need this file in dwg format as soon as possible, as soon as possible synonym polite, as soon as possible alternatives, sql developer skills required, as urgently as possible, write as little code as possible

Despre angajator:
( 75 recenzii ) Portsmouth, United Kingdom

ID Proiect: #29443291

Acordat lui:

SqlDevelopment

I can efficiently assist you with query development because I am Senior SQL Developer having 10-plus years of professional experience and highly advanced expertise in implementation of complex enterprise SQL solutions.

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% GBP în 1 zi
(36 Recenzii)
4.9

13 freelanceri licitează în medie 35£ pentru acest proiect

sumon355

Hello, As an expert in SQL, I am very much interested to do this project. I assume the database is in ms sql server? Thanks

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 2 zile
(227 recenzii)
7.6
tutulsoft

-- I understood your requirements from SQL output from your details description and example... yes this is somehow challenging to get exact result from SQL query as you have desired but it is possible , i am 21 years Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 3 zile
(18 recenzii)
5.0
adricabrelles

Hi I am a Senior DBA and sql programmer with more than 15 years experience. I can help you. Regards

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP în 1 zi
(10 recenzii)
3.9
gouravkumargupta

Hi there, Share me your db dump, and i have read your requirement. I think it can be done. i take payment once validated. I have 8 plus years of exp across various DB platforms. Regards, Gopal

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP în 1 zi
(4 recenzii)
3.4
merinsinha

SQL expert. I can help you. As 14+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP în 1 zi
(16 recenzii)
3.5
drivert

Hi , i am doing .net development using C#/Vb.net language since 2012 , and i have done many project on these duration and i am very well Polish of my skills. As per your Requirement i can do it easily and i will provi Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP în 1 zi
(1 părere)
1.0
amirgull

Hello Sir, I have vast experience of sql query. I will show you demo of your work when you want. Hope you look forward to work with me. Thank you

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP în 1 zi
(2 recenzii)
1.4
zhongjinshao9999

Hi Client! Your project is very interesting for me and also I have good experience in your project. If you hire me, you will get the wonderful results you need. I will wait your response. Thanks for reading my bid.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP în 1 zi
(0 recenzii)
0.0
valeriyaellert3

❤️Hello, Nocholas.❤️ I have read your sql project description carefuly and got to know you need help to sort your data. I have checked your attached images but I want to discuss about your project in detail via chat. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 4 zile
(0 recenzii)
0.0
bizmanas

Hi I have 15 years of experience in SQL Server Development. I should be able to help you with the project. Please ping me offline to Discuss further

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 4 zile
(0 recenzii)
0.0
EvaWang0214

Hi I feel you might need to have SQL function to help you decide which Rink to use when each time you have wo teams to play with eac other, right ? Also, you might does not want to use the rink that has just been used Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% GBP în 7 zile
(0 recenzii)
0.0
dreball

I actually really enjoy little puzzles like this, so I decided to go ahead and reproduce the sample data from your screenshot in my local instance. After a bit of playing around, I managed to write a script which solve Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP în 1 zi
(0 recenzii)
0.0