public class test1 {
 public static void test1() {
      
     Map<id,account> aMap = new Map<id,account>([Select Id,Name, Total_number_of_open_opportunities__c,Total_number_of_open_Upsel_opportunities__c, No_of_days_since_last_AE_activity__c
                        FROM ACCOUNT WHERE Assigned_AE__c != null AND (Assigned_AE__r.profile.Name = 'Sales Executive' OR 
   Assigned_AE__r.profile.Name = 'Premier Account Executive') AND No_of_days_since_AE_assigned__c >=60]);
     List<account> acc =  aMap.values() ;
   
   system.debug(acc.size());
   
   List<Opportunity> opps = new List<Opportunity>();    //list of all open opps
   List<account> acc1 = new List<account>();  
 
   
     
  if(acc.size() > 0)
   {
  // Query to get all open opportunites with no stage change in over 60 days 
   Map<id,opportunity> aMap2 = new Map<id,opportunity>([SELECT Id,accountid FROM Opportunity 
                                     WHERE AccountId IN :acc AND ISCLOSED = FALSE AND days_since_last_stage_change__c > 60 AND (RecordType.Name= 'New Business' OR RecordType.Name= 'Upsell')]);
       
       opps = aMap2.values() ;
   
  
     for (account a : acc )
     {
       
         
       If((a.Total_number_of_open_opportunities__c == 0 && a.Total_number_of_open_Upsel_opportunities__c == 0) || (a.No_of_days_since_last_AE_activity__c > 30 || a.No_of_days_since_last_AE_activity__c == 0) || opps.size()>0)
        { 
           
            a.Assigned_AE__c = null;
            acc1.add(a);
        }
       
     }
     update acc1;
   }
}
}