SQL Query Creation

Budget $300 - $500 USD
Bids 29
Average Bid $377
Status Closed

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 [url removed, login to view] 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!


Get Free Quotes For A Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • post3122 Profile Picture


    Hawthorn,  Australia

    I have more than 15 years of experience in MS Access (all versions) , VB and SQL Server.

  • saffireweb Profile Picture


    hyderabad,  India

    Has Four years experience Team in developing PHP, MySQL, .Net, C#, C++, Java and Ajax Driven Applications.

  • illuminesoft Profile Picture


    Solapur,  India

    Successfully finished over 430 Microsoft Access Database projects and 50+ .net/other projects. IllumineSoft is established in 1999. Illuminesoft is Intellisoft in India. The company has developed a number of database applications for Hospitals, Doctors, Trading Businessmen, Service Industry, Marketing Companies, Farm Houses, Pharmaceutical Drugs Trading, Chartered Accountants, Canvassing Agents, Libraries, Medical Service Company, Wood Logs Cutting Industry, Municipal Corporation, Web Searching Engine/Yellow Pages, CAD/AutoCAD, Day Care/School , strongly believe in quality engineering work. We train our staff to adopt all Software Engineering methodologies to develop Quality software. We have access to consultations of experts in software, medical science, Engineering science & technology, and textiles from India and abroad. We worked on more than 495 outsourced projects, with a team of more than 5-12 developers. We have more than 150 satisfied customers in about 23 countries.

  • jhaynes75 Profile Picture


    Stratford,  Canada

    Web Solutions - Internet, Intranet, websites and applications design and development

  • uniquesaiful Profile Picture


    Dhaka,  Bangladesh

    ? About 7 years of professional experience in both Desktop and Web based n-tier Business Application development. ? 3 years of team lead and management experience of about 8-10 developers in enterprise web and desktop based .net application development. ? I have experience of handling multiple project development simultaneously. ? Domain knowledge: ERP (HR, Accounts, Payroll, Inventory, Procurement, Sales & Marketing, Production, Distribution, Medical), Hotel Management, Hospital Management, Recruitment Business and BSC etc. ? Experienced in software development using Ext.Net, ASP.NET, C#.Net, VB.Net, ADO.Net, JavaScript, AJAX, VB6.0, HTML with databases such as SQL Server and MS Access. ? Well versed in Object Oriented Programming (OOP) using C#.Net/VB.Net and Fa├žade design pattern. ? Obtained expertise in the development of cross-tab/drill-down/on-demand reports using SQL Server 2005 Reporting Services (SSRS) as well as Business Objects Crystal Reports 8.0/9.2/10.0 and Data Report. ? Expertise in ASP.NET framework and AJAX based technologies with real life implementation. ? Comprehensive experience obtained in developing and modification of Multi-Threaded, Socket Programming and XML Web Service based application ? Sound experience in relational database design and implementation for enterprise application. ? Proficient in writing complex queries, stored procedures, views, triggers and user defined functions. ? Experienced in Software Development Life Cycle (SDLC) and conversant with Agile (SCRUM method) Development Process. ? Proficient in speaking, reading and writing English.

  • InSolWorld Profile Picture


    Ho Chi Minh City,  Vietnam

    If you need someone who can write Oracle SQL statements or PL-SQL procedures, functions as well as other data processing task, I will make you satisfy with the results with lowest prices when you hire me :) Implementing Java program, Java assignment using Eclipse, Netbeans. Doing university assignment to guarantee high marks :).

  • nicky789 Profile Picture


    Ha Noi,  Vietnam

    Nicky is a talent developer, he has done a lot of projects on freelancer with best feedbacks. Employers always satisfy with quality of product. Working independently on freelancers in big projects, ever leading $1.2 million budgeted project using Microsoft Azure and .NET platform He is confident to accomplish all projects that he bid.

  • hbxfnzwpf Profile Picture


    Beijing,  China

    I am a MMORPG game developer, mainly focus on server side, and I am also very proficient in client side development. I have 15 years programming experience now, and have worked for 7 years. I am an expert of C++ and Java, and proficient in developing under Windows, Linux/Unix, and Embeded environment. I promise to give you the best solution.

  • weonlydo Profile Picture


    Auckland,  New Zealand

    I am a freelancer domiciled in New Zealand. Don't let my time zone fool you though - I work around the clock and can adjust my schedule to work around your project. My core strengths are programming, APIs, scripts, macros, diagnostics, server administration, troubleshooting ... have I just covered all aspects of IT? I have been in the industry nearly two decades and have done all sorts of projects from front end through back end and the middleware in between. Check out my reviews and completion rate, then judge me for yourself when I complete your project. I apologize to the stones that WILL be turned to uncover the solution to your problems, none shall be spared!

  • poojaup555 Profile Picture


    Ahmedabad,  India

    Believe in Work