Help on dates between logic

[Suresh Babu Kommuri]

Hello Experts,

I am new to MySql and looking for your help on getting below logic.

I wanted to create a view or table against my existing order table.
The new table columns are customer Name, Order ID, Order_date, Group

I wanted to load data for above fields from Order table by flagging to the group column.
0-1 month
2-3 month
4-6 month
7-12 month
> 1 year

the conditions for flagging group column are.
0-1 month Currentdate(15/08/2017) to 30days (15/07/2017)
2-3 month 15th July to 15th June
4-6 month 15th June to 15th Mar
7-12 mont 15th Mar to 15th Dec
Any order > 1 year

Regards,

Suresh