SQL algorithm to compare users priorities

Given 3 users with preferences, 1-100, and values for each preference, 1-100, provide a SQL script that will score users 1 and 2 for "closest match" to user 3 for any number of preferences. You may provide additional optional parameters needed to be defined to accomplish this. You must populate your table with various cases required to prove your solution, and provide a very articulate description of why your solution provides the best answer.

Table of preferences has the following columns: UserID (int), PreferenceID (int), PreferenceLevel (int), Value (int).

You must provide me sufficient detail about your education and background to give me confidence you can provide a solution. Extra consideration given if you are willing to let me use your name, education, and background as the author of algorith for a non-profit organization.

Additional twist: Of user 3's preferences, for the highest preferences, in order, exceeding the value (by users 2 and 3) is preferred, and the higher the value is exceeded, the better. For the lowest preferences, in order, being below the value is preferred, and the greater the value is below user 1's value, the better.

By "closest match" I mean that user who, for highest preferences, exceeds the initial user by the greatest amount and, for the lowest preferences, is below the initial user by the greatest amount, all adjusted for the preference value of the initial user. So, there is a weighting (preferences) involved.

Here's an example: I have 2 preferences, one with weight 30, the other with weight 70. The value for the first is 1000 and the second 500. You value each 750 and 750 (everyone has the same total value!!!!!). A third person values these 800 and 700. Who's closer to me, you or the third person?

Compétences : Filtrage par motif, SQL

en voir plus : very articulate, use of algorithm, use algorithm, solution algorithm, match 3 algorithm, best match algorithm, porter stemming algorithm sql, stemming algorithm sql, compare results sql statements oracle, compare results sql oracle, procedure algorithm sql, search algorithm sql, point polygon algorithm sql, podem algorithm sql, hits algorithm sql, matching algorithm sql, compare time sql, compare sas sql, foxpro compare cnet sql 2005, compare php sql time

Concernant l'employeur :
( 9 commentaires ) Seattle, United States

Nº du projet : #10868585

Décerné à:


Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. I will prepare a solution to your problem and tomorrow I will update this with my proposal. Thank you, Bes Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 5 jours
(17 Commentaires)

14 freelance font une offre moyenne de $424 pour ce travail


Hi I am an SQL expert with several years of experience as MS SQL programmer. I have not clearly understood your requirement here, can you please explain it with some sample data (like you give a sample input data Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(75 Commentaires)

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I wouldn't call myself a master but I do work smart and do not rest until I get the job done. Please feel free to ping me an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(10 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(16 Commentaires)

HI My Notion : "No Satisfaction, No Payment" We have expertise in Web Design & Development. Please check our client reviews on Elance to determine the quality of our work.: please provide me requirement and star Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)

Sir, I can do this project but i need to know more about your project. I will accept project only when i'm 100% sure. Thanks! :)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(13 Commentaires)

You can contact with me at any moment to discuss your task. You can contact with me at any moment to discuss your task.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(5 Commentaires)

Hi Dear hiring Manager, I am interested in the position of (SQL algorithm to compare users priorities) you recently posted. I have been a professional Developer for 4+ years, and i am very familiar with PSD to HTML Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)

I am expert in SQL, Databases , Oracle Certified Professional. Have done some challenging query design tasks on this platform too. My education is BSCS, and MSCS. If you discuss in detail your requirements, i can do Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)

We have 8+years work experience in .NET,FLASH,C#,Linux,Visual Studio2010,Joomla,ASP,Javascript,Java,PHP,Python,Prestashop, MS access,SQL,Shell script,XML,moodle,AJAX,CMS,HTML,Drupal,SEO,CSS,wordpress,Bootstrap,Photos Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)

I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in programming and development I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)


%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

Hello, I'm taking an Engineer's Degree on Computer Science, currently in 3rd year. I've had 2 whole semesters on dbms & sql scripting and, after reading your requirements, I'm positive I can code a procedure with that Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)