CREATE TABLE depot_income_upto_31_03_2017 AS (SELECT * FROM depot_income WHERE income_date BETWEEN '2016-12-01' and '2017-03-31');
CREATE TABLE depot_exp_upto_31_03_2017 AS (SELECT * FROM depot_exp WHERE exp_date BETWEEN '2016-12-01' and '2017-03-31');
CREATE TABLE repair_upto_31_03_2017 AS (SELECT * FROM repair WHERE repair_date BETWEEN '2016-12-01' and '2017-03-31');
CREATE TABLE parts_cost_upto_31_03_2017 AS (SELECT * FROM parts_cost WHERE repair_date BETWEEN '2016-12-01' and '2017-03-31');
DELETE FROM depot_income WHERE income_date <= '2017-03-31';
DELETE FROM depot_exp WHERE exp_date <= '2017-03-31';
DELETE FROM repair WHERE repair_date <= '2017-03-31';
DELETE FROM parts_cost WHERE repair_date <= '2017-03-31';









CREATE TABLE depot_income_upto_31_03_2017 AS (SELECT * FROM depot_income WHERE income_date <= '2017-03-31')