Need some work done? Post a Project Today
Attention Scriptlance users, Scriptlance has been acquired by Freelancer.com! Find out more
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?)
G'day! Freelancer.com.au is the world's largest outsourcing and crowdsourcing marketplace for small business with professionals and growing! Australian small businesses can connect to our global labour pool just by posting a project! We connect users all around the world, from Canberra to Calcutta, Perth to Peru, Sydney to Sri Lanka and Melbourne to Mumbai.
The Freelancer.com.au talent pool is endless with skill sets ranging from programming, web and graphic design, SEO, SEM, the sciences, engineering, writing, data entry, accounting and legal services to name just a few. Our freelancers are ready and waiting to bid on your project right now and the average job size is under $200! You can find freelancers to design your logo, build your website, add a shopping cart and have your website up and running in just a week.
Are you looking to find freelance jobs or make money indirectly through our online affiliate programs? Sign up now and get started making money immediately!
Freelancer.com.au takes many measures to ensure your safety and security on the site. There is a secure milestone payment system and an online dispute system to protect your interests.
© Copyright 2013 Freelancer Technology Pty Limited (ACN 142 189 759)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)