MySQL query

$20-30 USD

Completato

Pubblicato

circa 2 anni fa

$20-30 USD

Pagato al completamento

This is a $20 job and as simple as this - the first freelancer to respond with a working query, I'll just award and pay that freelancer. Is this possible just using MySQL and not building page? I have 2 tables. Table1 has the following fields id, user_id, answer It has 100,000 entries with different unique user_ids and their corresponding answer to a answer "Which city do you live in" Table2 has answer, number_of_winners This table has 250 answers (different cities) and the corresponding number of winners we want to select at random. Can a query be built that will Select random set of users from Table1 with limit of number_of_winners for each distinct answer. Must be random and must be limited to the correct number of winners.

MySQL

Rif. progetto: 33687105

Info sul progetto

16 proposte

Progetto a distanza

Attivo 2 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

Assegnato a:

@estebansalpeter

Hi there! I hope this works for you, it worked for me just fine ;) Best regards, Esteban insert into results select T1.*, ROW_NUMBER() OVER(PARTITION BY answer) as winner_nr, RAND() as winner_order from Table1 T1 order by [login to view URL]; select T1.* from results T1 inner join Table2 T2 on T1.answer=[login to view URL] where winner_nr <= T2.number_of_winners order by winner_order;

$20 USD in 1 giorno

5,0

(7 valutazioni)

4,2

16 freelance hanno fatto un'offerta media di $91 USD

@BitLabs

Dear sir, I have gone through your outsourced requirement " MySQL query " and have analyzed that I have right credentials ( MySQL ) to execute your esteemed project. You will never go wrong choosing me :)

$20 USD in 7 giorni

5,0

(48 valutazioni)

6,0

@tanvir123047

Yes it's possible to select random winners from the data base without making a landing page. Your task is tricky but I can solve for you in hours. If you find me fit for the work then let's have a chat!

$20 USD in 1 giorno

5,0

(4 valutazioni)

2,4

@lewandowskijaro5

Hi! I've read your article with interests. What you want is just same as what I often produce, I think. Some days ago, I finished the task as similar as your idea perfectly for my friends. If we share our idea each other, we may get the excellent success in time and become best friends. Indeed I hope so. I like best to help my good friends, always. If you make a decision, the best result is a piece of cake for us. Best Regards.

$20 USD in 1 giorno

5,0

(5 valutazioni)

1,6

@MaasSally

Hello, I have read the description carefully and understood the requirement. We can connect both tables and then select random users and apply a limitation to the winners. This can be done. Please PM me with more details. Thank you

$20 USD in 1 giorno

5,0

(1 valutazione)

1,1

@shatkolera

Hello. Happy Firday! I am a full-stack developer. I feel confident in your project because I have read your requirements carefully and worked on projects you are familiar with before. Last 8 years driven by programming passion I've designed and developed many websites and apps with a wide variety of modern web technologies. My tech stack is Front-end(React, Vue, ..), Back-end(Laravel, Wordpress, Django, Flask, Node.js, Express) and Database(MySql, MongoDB, ..) I'm available 24/7 for your projects I have enough ability and you can look forward to long-term cooperation with me. I want to work with you. Please contact me. Thank you Valeriya

$1.125 USD in 7 giorni