Accepted Solution with LEFT JOIN


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

Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.