Customers Retentions

These are the segments that i need to create report  on  

Segments: 

• Retained - users who have completed orders in previous 30 days and last 30 days 
• Reactivated - user who last completed orders between day 60 and day 90 and placed an order in the last 30 days 
• New - users who completed there first order in the last 30 days  

Sub-segments: 

• Rookie - Users who completed 1 order in a given time period 
• MV - Users who completed 2 orders 
• HV - Users who completed more than 2 orders 

there is two table where orders table and users table 

orders table contains id,amount , completed date,user_id

users table contain id,name,phone and email