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?
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
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
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
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
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! :)
You can contact with me at any moment to discuss your task. You can contact with me at any moment to discuss your task.
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
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
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
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