Mysql query - repost

Closed Posted Oct 30, 2013 Paid on delivery
Closed Paid on delivery

I need sells from date range 2013-01-01 - 2015-01-01 , group by Category.

Trying to create a query that outputs sells by Category, the problem is that the "Sub category 2" was change there' s Parent_Category/parent_id and the results must be on 2 rows for "Product 1".

Please, NO PHP only Mysql

Please, check attached file.

MySQL

Project ID: #5076579

About the project

11 proposals Remote project Active Dec 6, 2013

11 freelancers are bidding on average $28 for this job

rinsadsl

Hi there I can help you on this project. I cannot understand this points. Please explain in more detail `the problem is that the "Sub category 2" was change there' s Parent_Category/parent_id and the results More

$33 USD in 0 days
(115 Reviews)
6.5
Aloknano

lets start................................................................. Thanks Technovinity Systems Pvt Ltd

$30 USD in 1 day
(13 Reviews)
4.5
tikumishra

I can do this, provided you give me your MySQL PHPADMIn access. I can do this in few hours and deliver you.

$35 USD in 1 day
(13 Reviews)
4.1
jporwal

Hello & Greetings, I am an expert in MySQL and can do this task for you. Please see reviews for my experience. I will help solve your problem quickly. Can start immediately once you create milestone. Thanks & Re More

$20 USD in 1 day
(10 Reviews)
3.8
eComOS

Hello Troj, I have gone through your outsourced requirement "Mysql query - repost" and have analyzed that I have right credentials (MySQL) to execute your esteemed project. ===== Why choose me? ===== ✓ 5 More

$28 USD in 0 days
(14 Reviews)
3.7
ErwanMas

Hello , I am a senior in sql database administration and in linux administaraion . I am a senior in develloppemnt in php,perl , and in other language . Can i have access to phpmyadmin ? or can you give a partial More

$54 USD in 1 day
(4 Reviews)
3.2
RajakScripts

Hi Troj, You mean that you want the output should be 2 instead of 1, the first one should contain 2 sells (the sales was from 2013-03-01 or earlier), the second row will contain 4 sells (the sales was from AFTER 201 More

$20 USD in 0 days
(1 Review)
2.7
brandnewunpunk

I have tons of MySQL experience professionally and would love to help you with this. Message me and we can discuss details further.

$22 USD in 1 day
(2 Reviews)
1.1
jamal8t2

Dear sir I have a lot of experience I will provide you fast, efficient and quick response with in no time

$25 USD in 1 day
(0 Reviews)
0.0
FrancoAl

A proposal has not yet been provided

$30 USD in 1 day
(0 Reviews)
0.0
paris2785

VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. I'll complete your task and send you photo screens. If you are happy you'll award me More

$19 USD in 3 days
(0 Reviews)
0.0