In Progress

Complex MySQL Queries on Given Table

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.

Skills: Database Administration, MySQL, SQL

See more: complex mysql queries given table, table data structure, sql queries, sql mysql, queries, database queries, complex data entry, bone, sql retrieve table, mysql data grab, mysql grab, write sql queries, table queries, insert mysql table, mysql containing, queries sql, given, given following requirements, complex format, word database sql, table requirements word, dog app, description dog, sql dummy, mysql data word

About the Employer:
( 2 reviews ) Chicago, United States

Project ID: #4620603

22 freelancers are bidding on average $11/hour for this job

kchg

Hello, sir I'm interested with your project. I'll do it for you. Regards.

$30 USD / hour
(147 Reviews)
8.1
eperfections

Hey Dog Done. I can do this job. Have expertise in writing complex queries.

$12 USD / hour
(161 Reviews)
6.8
bgeorge

Ready to start.

$12 USD / hour
(223 Reviews)
6.3
weonlydo

"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 / hour
(53 Reviews)
5.8
feninsoftech

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|S More

$13 USD / hour
(29 Reviews)
6.0
priyankjini

dog bone Hi, Thanks for your description .I expert in DB. Please check PMB. Thanks.

$15 USD / hour
(15 Reviews)
4.7
codeCrafter10

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 / hour
(18 Reviews)
4.3
mdakteruzzaman

Hi I'm expert in database design and modification. pls check pmb

$8 USD / hour
(19 Reviews)
4.7
spcinc

Hello. SQL Expert here. I can help you. Best Regards.

$15 USD / hour
(3 Reviews)
3.6
AliSafder

Hi, I can write queries for you...

$12 USD / hour
(13 Reviews)
3.4
AccuPro

Hello, I can help.

$8 USD / hour
(6 Reviews)
3.5
jvpolivares

Hi, dog bone. Can solve your query. For further details, just contact me.

$10 USD / hour
(2 Reviews)
2.6
jvankov

Dog bone! Please, check PM.

$8 USD / hour
(1 Review)
1.6
wentie727

Dear sir! I am ready for you now. Please check my P.M. Thanks.

$12 USD / hour
(3 Reviews)
1.0
tspbd

dog bone, Hi! Let me do the job for you.

$10 USD / hour
(1 Review)
1.0
truongbk24

dog bone, plz check my PM for more details

$10 USD / hour
(2 Reviews)
0.5
twimalasuriya

I'm writing many complex mysql querries every day. I can do this. dog bone

$8 USD / hour
(0 Reviews)
0.0
cliffroot

'dog bone' Hello, I can probably do this project for you. Please read your PM. Thanks,

$8 USD / hour
(0 Reviews)
1.5
JavaidAkram

i have experience with sql queries from 2002 . so i can do this job

$12 USD / hour
(0 Reviews)
0.0
tree1891

Dear sir, i'm ready

$8 USD / hour
(0 Reviews)
0.0