[SQL] Update da ricordare nei giorni tristi

-- fix LOCK
UPDATE myschema.mytable                                        
SET myLOCK = ''                                          
WHERE myPROG IN (                                            
  SELECT RS1.PROG FROM (                                       
    SELECT A.myPROG AS PROG,                                 
           SUM (                                               
               CASE A.myAMBI                                 
                    WHEN 'QA' THEN 100                         
                    WHEN 'DA' THEN 010                         
                    WHEN 'BA' THEN 001                         
                    ELSE 0                                     
               END ) AS SOMMA                                  
    FROM myschema.mytable A                                    
    WHERE A.myAMBI IN ('BA','DA','QA')                       
    AND myLOCK <> ''                                     
    GROUP BY A.myPROG                                        
    ) AS RS1                                                   
  WHERE RS1.SOMMA < 100                                        
  )                                                            
AND (myAMBI = 'DA' OR myAMBI = 'BA')