Closed

SQL Query Creation

We are looking for a talented freelancer who can write SQL queries to automate the analysis of a social media analytics tool we are building.

This project requires advanced SQL ability and familiarity with Microsoft ACE OleDB. Developer will be provided with database (currently ACCESS) and a series of sentences, and will write a single SQL statement per sentence which can produce the data needed for each sentence.

Here is an example of a sentence and SQL query:

Example: "The average age amongst 11 competitors is 3.01 years."

SQL: SELECT COUNT(competitors), AVG(age) FROM database

Developer must possess excellent English skills and availability via Skype. Work will be ongoing, with potential adaptation into mySQL or SQL Server.

The successful freelancer will be whoever can provide working SQL queries based on the data. Attached is a sample Access database containing a sample data set. Below are three sample written takeaways that can be generated from the dataset. Please respond with a private message with your answer - we will validate for accuracy.

Sample Takeaways - please answer with how this can be generated via a SQL Query:

-A total of X posts were generated across Y reviewed brands.

-Since START DATE, X selected competitors have posted a combined Y posts, engaging with approximately Z of these users.

-Exceeding 500,000 fans establishes leadership in this category, which is accomplished by McDonald's and Subway. (This number will vary in each data set. Is it possible to use one statistical deviation above the median?)

Good luck!

-Daniel

Skills: .NET, Database Administration, Microsoft Access, MySQL, SQL

See more: we looking for sql server developer, total freelancer users, successful freelancer, sql server developer freelancer, sql queries freelancer, sql developer freelancer, sql database developer freelancer, needed a social media freelancer, microsoft sql freelancer, microsoft server freelancer, microsoft freelancer server, microsoft access database developer, media freelancer database, looking for analytics freelancer, leadership skills, how to work on freelancer 14 years, how to successful freelancer, how to be freelancer in social media, freelancer z, freelancer total users, freelancer statement, freelancer sql net, freelancer sql developer, freelancer sql database, freelancer sql c#

About the Employer:
( 56 reviews ) Toronto, Canada

Project ID: #4130503

29 freelancers are bidding on average $377 for this job

illuminesoft

can you explain little more, the tables you provided have all the data for these queries ? if so I could not find no. of fans stats

$420 USD in 7 days
(358 Reviews)
7.7
forrestwang

hi sir, pls check your inbox.

$500 USD in 10 days
(37 Reviews)
6.5
sandeep25101982

Hi .Net and SQL expert here. Please check private message for relevant work done by me and portfolio. Looking forward to hear from you . Thanks

$300 USD in 20 days
(37 Reviews)
6.5
jhaynes75

Professional software developer with over 13 years experience. Please see PM.

$300 USD in 5 days
(29 Reviews)
6.1
weonlydo

Let's talk so that we can nail down the scope and scale of your project. Please see my references and answers to your questions in a PM.

$300 USD in 4 days
(34 Reviews)
5.4
tamrakar81

Hi, I have gone through your requirement and I am glad that We can accomplish this task, Please give us opportunity to work with you. Thanks, TTS Team

$300 USD in 5 days
(34 Reviews)
5.1
nicky789

Bid to ask

$500 USD in 7 days
(6 Reviews)
5.0
indivar

I want to congratulate you for reading this. We are quite interested to write the code for your the data you have sent. We are very capable and able to deliver what you are looking for.

$500 USD in 5 days
(2 Reviews)
5.2
romei

Hello, I am willing to work for a fixed price per SQL query. Please find the answers to your samples in the attached message.

$350 USD in 10 days
(4 Reviews)
4.9
Eliteprog

Hi, First of all thanks for posting this project, I am available to provide you economical services for SQL and analytical queries in Sql server and Mysql, I have read and understood all of your details. I am exper More

$350 USD in 11 days
(14 Reviews)
4.8
mmsolutionz

Sir, We can work on the SQL Queries as per your requirements! Please check your Private Message, we have sent answers to your sample queries! Let us know! Arsalan

$500 USD in 20 days
(21 Reviews)
4.8
sthakral

Hello, I am a highly experienced Database developer and Modeler. I have more than 15 years of experience behind me. The solution to the statements you asked for are attached. Please see PMB for details.

$350 USD in 7 days
(4 Reviews)
3.8
mystic19

I have answered your questions. So, please, check your PMB. I have clear understanding about the project as it matched with my experience and expertise very well.

$300 USD in 20 days
(6 Reviews)
3.8
mukhan88

Hi I can do that simple task

$300 USD in 5 days
(3 Reviews)
3.6
lokeshk9936

Hi, Please see PM.

$300 USD in 5 days
(4 Reviews)
3.1
hbxfnzwpf

I am senior c++ developer, and I have made c compiler myself, so I am very familar with lexical and grammar analysis, I can do it for you.

$300 USD in 5 days
(3 Reviews)
1.8
techlegends786

We have the know how to work on this project.

$300 USD in 5 days
(1 Review)
1.8
InSolWorld

Hi, sir. I have completed your sample task. So, Please check your inbox. Hope that I will have a chance to work with you in this project.

$300 USD in 10 days
(2 Reviews)
1.7
anomanpk

I would like to offer my services for the above mentioned job.

$400 USD in 10 days
(1 Review)
1.4
Dev01NavNet

Hi, see pmb.

$400 USD in 5 days
(1 Review)
1.4