SQL Query Creation

Avg Bid (USD)
Project Budget (USD)
$300 - $500

Project Description:
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!


Skills required:
.NET, Database Administration, Microsoft Access, MySQL, SQL
Additional Files: Sample.accdb
Hire danielrobinson
Project posted by:
danielrobinson Canada
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 420
in 7 days
Hire forrestwang
$ 500
in 10 days
$ 300
in 20 days
Hire jhaynes75
$ 300
in 5 days
$ 300
in 4 days
$ 300
in 5 days
$ 500
in 7 days
Hire indivar
$ 500
in 5 days
$ 350
in 10 days
$ 350
in 11 days