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.
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