( gelei | 2025. 05. 19., h – 00:15 )

Az "algoritmus":

DELETE FROM employees
WHERE salary >= (
    SELECT MIN(salary)
    FROM (
        SELECT salary
        FROM employees
        ORDER BY salary DESC
        LIMIT (SELECT CEIL(0.03 * COUNT(*)) FROM employees)
    ) AS top_3_percent_salaries
)
AND is_essential_or_friend_of_ceo = FALSE;