delete

tutorijal
DELETE FROM  z16591  e
WHERE  (SELECT r.region_name
        FROM departments d, locations l, countries c, regions r
        WHERE d.department_id = e.department_id
        AND d.location_id =l.location_id
        AND l.country_id=c.country_id
        AND c.region_id=r.region_id) <> 'Asia'
AND  e.manager_id= (SELECT z.employee_id
       FROM z16591 z
       WHERE  (SELECT COUNT(a.employee_id)
            FROM z16591 a
            WHERE a.manager_id = z.employee_id
           )  = 3
       AND (SELECT  c.salary
            FROM z16591 c
            WHERE   z.manager_id=c.employee_id
           ) >
           (SELECT d.salary
           FROM z16591 d
           WHERE (SELECT COUNT(f.employee_id)
                  FROM z16591 f
                  WHERE f.manager_id=d.employee_id
                  )   =
                  (SELECT MIN(COUNT(g.employee_id))
                   FROM z16591 g
                   GROUP BY g.manager_id
                  )
           )
       )