UPDATE SBASLIK SET SATFISEKUNO = '2' WHERE SATGENELTOP > 0 AND SATFISEKUNO IS NULL AND SATTARIHI >= DATEADD(-6 MONTH TO CURRENT_DATE) AND EXISTS ( SELECT 1 FROM SBASLIK AS ALT WHERE ALT.SATFIRMAADI = SBASLIK.SATFIRMAADI AND ALT.SATTARIHI = SBASLIK.SATTARIHI AND ALT.SATGENELTOP > 0 AND ALT.SATFISEKUNO IS NULL AND ALT.SATFIRMAADI<>'PAREKENDE' GROUP BY ALT.SATFIRMAADI, ALT.SATTARIHI HAVING COUNT(*) > 5 );