Leetcode Problem 577. Employee Bonus

577. Employee Bonus

Leetcode Solutions

Using LEFT JOIN and WHERE Clause in SQL

Start the SQL query with a SELECT statement to retrieve the desired columns, which are Employee.name and Bonus.bonus.
Use LEFT JOIN to combine the Employee and Bonus tables on the empId column. This ensures that all employees are included in the result set, even if they do not have a corresponding bonus entry.
Apply a WHERE clause to filter the results to include only those records where the bonus is less than 1000 or is NULL.
The final result set will include the names of the employees and their respective bonuses, if the bonus is less than 1000, or NULL if they did not receive a bonus.

erDiagram
    Employee {
        int empId PK
        varchar name
        int supervisor FK
        int salary
    }
    Bonus {
        int empId PK FK
        int bonus
    }
    Employee ||--o{ Bonus : has

Using Subquery and LEFT JOIN in SQL

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 577. Employee Bonus

Leetcode Solutions

Using LEFT JOIN and WHERE Clause in SQL

Solution Idea

Query Steps

Code Implementation

Using Subquery and LEFT JOIN in SQL

Ask Question

Suggested Answer