SQL problem - Employee Bonus

1 min read 67 words

Problem

Query

SELECT
    name,
    bonus
FROM
    Employee AS e
LEFT JOIN
    Bonus AS b
ON
    e.empId = b.empId
WHERE
    bonus < 1000 OR bonus IS NULL