Complex MySQL Queries on Given Table
This project was awarded to weonlydo for $15 USD / hour.Get free quotes for a project like this
Project Budget$8 - $15 USD / hour
I have a need for a series of Database Queries to retrieve a given result set. I'd like to send you the database tables, then give you a description of the result set that I want to retrieve. I can also give you what I want the result set to look like. I am expecting the SQL queries for each description in return.
I've attached an SQL file containing a structure for a new table and some dummy data to insert. I'm looking to basically write some queries to grab the result set and format it in a way that makes sense for my app.
The table has a date column and an amount column. I want the total amount of every entry in the table, grouped by each individual day so that the result set looks similar to the following:
To make sure you've read and understand the requirements, please include the word "dog bone" in your bid offer. I will not accept your bid if you do not include the word "dog bone" in your message.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online