Creation of MySQL views

Completed Posted Nov 24, 2011 Paid on delivery
Completed Paid on delivery

For an urgent project we have, we need to have a couple of MySQL views created in order to have quick statistics. Here are the tables and their description:

1. sender (id, msisdn, type, registration_date)

- the [login to view URL] can be either T or S

2.voting_office (id, code, address, site, etd, circonscription, province)

- the [login to view URL] is a unique varchar

- a [login to view URL] can have many [login to view URL]

- a [login to view URL] belongs to a single [login to view URL]

- a [login to view URL] can have many [login to view URL]

- a [login to view URL] can have many [login to view URL]

- a [login to view URL] can have many [login to view URL]

3. incoming_result (id, sender, sender_type, office, candidate_1, candidate_2, candidate_3, candidate_4, candidate_5, candidate_6, candidate_7, candidate_8, candidate_9, candidate_10, candidate_11, time_update)

- the [login to view URL] is the [login to view URL]

- the incoming_result.sender_type is the [login to view URL] of the [login to view URL] of belonging [login to view URL] (so either T or S)

- the [login to view URL] is the [login to view URL]

What we need as views are, for each type of senders

1. the sum of voices for each candidate_x grouped by sites (site, candidate_1, candidate_2, candidate_3, candidate_4, candidate_5, candidate_6, candidate_7, candidate_8, candidate_9, candidate_10, candidate_11)

2. the sum of voices for each candidate_x grouped by etd (etd, candidate_1, candidate_2, candidate_3, candidate_4, candidate_5, candidate_6, candidate_7, candidate_8, candidate_9, candidate_10, candidate_11)

3. the sum of voices for each candidate_x grouped by circonscription (circonscription, candidate_1, candidate_2, candidate_3, candidate_4, candidate_5, candidate_6, candidate_7, candidate_8, candidate_9, candidate_10, candidate_11)

4. the sum of voices for each candidate_x grouped by province (province, candidate_1, candidate_2, candidate_3, candidate_4, candidate_5, candidate_6, candidate_7, candidate_8, candidate_9, candidate_10, candidate_11)

This then makes a total of 8 views needed.

This project is urgent and please don't bid if you have no experience writing SQL codes (this one will be for MySQL) and don't bid if your price is more than 50 USD.

This project should be finished at latest 5 hours after acceptance of the project by the coder in order to receive full payment. We will need to test the scripts against our data in order for us to be sure it is working so we can release the money.

This should be the data you could work with, the work should be done in one day. Provide me the script for one of the view, so I can test it myself and if it works, I will give you the project.

Regards,
Daniel

MySQL SQL

Project ID: #1308718

About the project

7 proposals Remote project Active Nov 24, 2011

Awarded to:

sarannya1986

Dear Sir, I have the queries written for your requirement. Please view the untested query i sent to your PMB, for the first view you have asked for. Kindly accept my BID if you want me to procced with testing of the More

$50 USD in 1 day
(1 Review)
1.4

7 freelancers are bidding on average $43 for this job

HussienSharaf

I can create these views in less than 4 hrs Hussien sharaf

$50 USD in 0 days
(21 Reviews)
6.9
diepbp

I am confident to handle your project. Please check your inbox for details, thank you.

$45 USD in 0 days
(16 Reviews)
4.7
redscraper

Hello, I can able to do this job. I have more than 5 years experience in Excel VBA, MS access web scrape script, php, css, MSSQL, wordpress, joomla, software and web development using c#. Looking forward to hear More

$35 USD in 1 day
(3 Reviews)
3.0
bthomas3598

If you could provide a dump of the tables as they exist now, not with all the records of course but with some dummy rows so that I could verify that all the column types match up there is not reason I couldnt have this More

$40 USD in 1 day
(0 Reviews)
0.0
charouel

hello sir, I guarantee you a good work in the state delay

$30 USD in 0 days
(0 Reviews)
0.0