MERITREWARDS.sql

    0

    0

    The SELECT statement in the code selects all the employee IDs and their corresponding name from the employee_information table and the last_quarter_bonus table, where the employee_ID value is from the employee_information table and the bonus value is from the last_quarter_bonus table. The WHERE clause checks to see if the employee's division is equal to "HR" and the bonus value is greater than 5000.

    SELECT ei.employee_ID, ei.name
    FROM employee_information ei
    JOIN last_quarter_bonus b ON b.employee_ID = ei.employee_ID
    WHERE ei.division LIKE 'HR'
    AND b.bonus >= 5000;
    Codiga Logo
    Codiga Hub
    • Rulesets
    • Playground
    • Snippets
    • Cookbooks
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.