SELECT  Count(Sno) as NoOfAppsLTHr
         FROM  my_QRY_ITEMS
         WHERE  status=
         AND   AppComesFrom=
         AND   CustAccNo like 
         AND   myTime < 121
         AND    nydate between to_date('#NBetween1#','DD-MM-YYYY HH24:MI:ss') AND to_date('#NBetween2#','DD-MM-YYYY HH24:MI:ss')  
                   
        
         SELECT  Count(Sno) as NoOfAppsMTHr
         FROM  my_QRY_ITEMS
         WHERE  myStatus=
         AND   AppComesFrom=
         AND   CustAccNo like 
         AND   myTime > 120
         AND    myDate between to_date('#NBetween1#','DD-MM-YYYY HH24:MI:ss') AND to_date('#NBetween2#','DD-MM-YYYY HH24:MI:ss')  
          
        
        
        
        
       
       
       
     
            
               
               
               
               
               
               
           
 
           
 
          
         
       
    
       
       
         
                   
        
         SELECT  Count(Sno) as NoOfAppsLTHr
         FROM  my_QRY_ITEMS
         WHERE  myStatus=
         AND   AppComesFrom=
         AND   CustAccNo like 
         AND   myTime < 121
         AND    myDate between to_date('#NBetween1#','DD-MM-YYYY HH24:MI:ss') AND to_date('#NBetween2#','DD-MM-YYYY HH24:MI:ss')  
                   
        
         SELECT  Count(Sno) as NoOfAppsMTHr
         FROM  xxx_QRY_xxx
         WHERE  myStatus=
         AND   AppComesFrom=
         AND   CustAccNo like 
         AND   myTime > 120
         AND    myDate between to_date('#NBetween1#','DD-MM-YYYY HH24:MI:ss') AND to_date('#NBetween2#','DD-MM-YYYY HH24:MI:ss')