CCA159 : Task Scenario-25

Problem Scenario 25:  Please accomplish following

1. Get number of orders by order_status for a given date '2013-12-14'

2. Get number of completed orders for each date before '2013-12-14 00:00:00.0'

3. Get number of pending, review and onhold order for each date for the month of 2013 December.

4. Get number of orders by order_status, which in  review, hold or in pending status for all the orders placed between '2013-12-01 00:00:00.0' AND '2013-12-31 00:00:00.0'