MYSQL getting data from 2 tables

$250-750 USD

Fechado

Publicado

há quase 8 anos

$250-750 USD

Pago na entrega

As per screenshot, I want to output each player_id (player name taken from another table using player_id) And for each player_id with WEEKPOINTS greater than 0 - I want to count the number of 50 weekpoints they have and count the number of 100 weekpoints they have. So is this example it would be Player_id 1 (Cech is the playename) 1 (50 weekpoints) and 1 (100 weekpoints) 50 to be change the "yellow cards" and 100 changed to "red cards" Player_id 11 (Ramsey) 1 (50 weekpoints) And just to note the same player_id could be selected by different USER_ID's so I just want to count the weekpoints once per week (see frozen_id = 9 and 13 - who picked same player in week 2 so just count this 100 weekpoints once)

PHP

Software Architecture

ID do Projeto: 10862371

Sobre o projeto

45 propostas

Projeto remoto

Ativo há 8 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

45 freelancers estão ofertando em média $321 USD for esse trabalho

@kchg

Hello, sir. My ranking is TOP 5TH in freelancer.com as you can see my profile: (https://www.freelancer.com/u/kchg.html). I'd like to discuss with you in detail. Kind Regards

$250 USD em 1 dia

4,9

(432 avaliações)

9,7

@helmot

Too simple task! I can make such query for you (or script that do that) in an hour with just $100! Are you interested? Le'ts start just now! Thanks, Helmot

$250 USD em 2 dias

4,8

(187 avaliações)

8,1

@gslogics123

Hello Sir I can create the MYSQL queries for data updation right away. I am available via chat to discuss. Please check my profile for work and experience. Regards Ashwin

$264 USD em 0 dia

5,0

(265 avaliações)

7,4

@Infenixwebs

Hi, I have experience in web projects, if you check my reviews you will see that I have gotten excellent results from previous employers. If you have any questions or concerns please do not hesitate to contact me, thanks!

$250 USD em 4 dias

4,9

(132 avaliações)

7,5

@darkwind

Hello, So the output would be a list of ALL players for that particular week, right? Will there be an option to select weeks or just display the latest week? How will it be sorted? By name, red cards or yellow cards? Sample output: Week 2 PlayerName :: Yellow Cards :: Red Cards SamplePlayer1 :: 5 :: 6 SamplePlayer2 :: 3 :: 4

$266 USD em 2 dias

4,8

(286 avaliações)

7,7

@gangabass

I'm SQL expert with HUNDREDS of completed projects that's why I'm sure you'll be impressed with my work. I can create MySQL query you want in less than a day and I can offer you best price here. All I need to start is to know what MySQL version you're using. Thanks. Roman

$252 USD em 1 dia

5,0

(412 avaliações)

7,3

@jacekphp

Hello, I can see that you need to build an efficient MySQL query that will make some calculations of various players' characteristics, e.g. yellow/red cards. I can definitely do it for you quickly. Could we discuss it in details, please? Many thanks, Jacek Francuz

$250 USD em 2 dias

4,9

(32 avaliações)

7,3

@BitLabs

Hello, I have gone through your outsourced requirements "MYSQL getting data from 2 tables" and have analyzed that I have right skills (PHP, Software Architecture) to execute your esteemed project. I will complete your project within 2 weeks, LIFETIME error free guarantee and provide 365 days (ONE YEAR) support... ===== Why choose me? ===== 5.0 / 5.0 rating, 100% completion rate, 100% on-time completion, 100% on-budget :) Kindly, check my profile: http://www.freelancer.com/u/BitLabs.html I work smart, hard, and strictly bid only what we can do! No sub-contracting... ever! You will never go wrong choosing me :)

$353 USD em 10 dias

5,0

(113 avaliações)

6,7

@NayaPakistan

Hello. This can be done using joining 2 tables in the MySQL query. Looking forward!

$250 USD em 1 dia

4,9

(322 avaliações)

6,8

@kamranashrafvw

i can fix your issue right now. i will do the very professionally and on time. i will try to built long term relations with you by proving my skills on your job.

$333 USD em 2 dias

5,0

(39 avaliações)

6,5

@rubarita

Hi, I am highly interested to work on this project. I understand your requirements I am 100% sure I can complete within timeline with quality Regards Hasan

$250 USD em 10 dias

4,9

(77 avaliações)

6,5

@mikeblane

Warm Regards, I am pleased to inform you that your PR matches our expertise who own all the right credentials to execute this job in a very proficient way with a proven track record which shows our dedication towards satisfactory work, I request you to please initiate the discussion so that I can reach you efficiently, I can schedule an in-person to have better understanding on every minute requirement, final quote and deadline. Ready to share Portfolio on demand.(Committed instant reply)

$736 USD em 10 dias

4,3

(65 avaliações)

6,8

@prolinkerx

Dear sir, I've read your requirement twice and checked the attached image carefully. As an expert in PHP/MySQL with 8+ years of experience, I could be a good fit. I'll complete it right now for you (Within today CEST) – with 100% accuracy. Kind regards, Francis T. –-–-–-–- Note that since your budget ranger is 250-750 (mistake?), I can't bid lower than $250, But actually, I can do it with much more lower price if needed

$250 USD em 0 dia

5,0

(100 avaliações)

5,5

@Adwitiya012

We have 6 resources in our team. We have 2 frontend and 4 backend developer. We'll also look into our portfolio. This will be done within the timeline. We will be highly obliged if you make business relation with us. We have some queries like 1) I have seen your table with data. Can you please share where the sql will be implemented? 2) Required file system We can discuss over this chat.

$250 USD em 1 dia

5,0

(28 avaliações)

5,3

@abapguru

A proposal has not yet been provided

$250 USD em 5 dias

5,0

(68 avaliações)

5,2

@imanolie

Hi, I am an experienced enterprise developer. I have experience working with mysql and I can do this task for you in a timely manner. I can do this for less also ( about 150$ as it is not a really hard task, but you will need to edit project details to give you another proposal) Let's have a short chat to discuss all the details. Looking forward working with you, Ioan

$250 USD em 0 dia

5,0

(14 avaliações)

5,2

@vmindgroup

Hi there - My name is Michael Phu.I’ve read your brief and can see that we can work together I'm on Java Senior software developer with over 5 years of programming experience in a variety of roles across a number of banking industries. I can assure you that if you work with me once, you will always work with me for these kind of projects. Please contact to me so that we can discuss in more detail. Have a nice day !

$250 USD em 1 dia

5,0

(4 avaliações)

5,0

@pranotosh

I'm a Web Developer having a lot of experience in PHP,Codeigniter,MySql,HTML5,CSS3,Javascript,jQuery,Ajax etc. I can assure you quality service. Please consider my bid. Thanks

$300 USD em 5 dias