Find Jobs
Hire Freelancers

Complex MySQL Queries on Given Table

$8-15 USD / hour

In Progress
Posted almost 11 years ago

$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. Example: 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: {[ date: 2013-06-01, total_transactions: 0 ], [ date: 2013-06-02, total_transactions: 0 ], etc.. } 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.
Project ID: 4620603

About the project

18 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average $10 USD/hour for this job
User Avatar
Hey Dog Done. I can do this job. Have expertise in writing complex queries.
$12 USD in 10 days
4.8 (180 reviews)
7.1
7.1
User Avatar
Hi, I have 8.5 years experience in MySQL database design, Queries writing and indexing. Expertize in ASP.Net|C# Win Forms|SharePoint2010|EF|WebServices|WCF|Sql Server 2005/2008R2|MYSQL||HTML5|CSS3|Jquery|Ajax|JSON|SSRS2008.
$13 USD in 20 days
4.9 (51 reviews)
6.8
6.8
User Avatar
"dog bone" I write about 4,000 "complex" MySQL queries every half year, so this will be easy for me and also efficient for you. Please check out my completion rate and reviews.
$15 USD in 2 days
5.0 (62 reviews)
6.0
6.0
User Avatar
Ready to start.
$12 USD in 3 days
4.7 (214 reviews)
6.2
6.2
User Avatar
Hi, I can write queries for you...
$12 USD in 3 days
5.0 (33 reviews)
4.8
4.8
User Avatar
Hi I'm expert in database design and modification. pls check pmb
$8 USD in 3 days
4.5 (20 reviews)
4.8
4.8
User Avatar
Hi, (dog bone) I have several years of experience in MsSQL. I would love to help you with this queries. You can check my feedback. Can you put the sample database? Thanks, Emilian.
$11 USD in 20 days
5.0 (18 reviews)
4.3
4.3
User Avatar
Hello, I can help.
$8 USD in 8 days
5.0 (6 reviews)
3.5
3.5
User Avatar
Dog bone! Please, check PM.
$8 USD in 20 days
5.0 (1 review)
1.6
1.6
User Avatar
Dear sir! I am ready for you now. Please check my P.M. Thanks.
$12 USD in 3 days
5.0 (3 reviews)
1.1
1.1
User Avatar
dog bone, Hi! Let me do the job for you.
$10 USD in 3 days
5.0 (1 review)
1.0
1.0
User Avatar
'dog bone' Hello, I can probably do this project for you. Please read your PM. Thanks,
$8 USD in 5 days
0.0 (0 reviews)
1.5
1.5
User Avatar
dog bone We are ready to work for this project.....
$8 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
DOG BONE! Pls check my PM. When shall we start?
$8 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir, i'm ready
$8 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have experience with sql queries from 2002 . so i can do this job
$12 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm writing many complex mysql querries every day. I can do this. dog bone
$8 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Chicago, United States
5.0
2
Payment method verified
Member since Jan 26, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.