Description
Write a SQL query to find employees whose bonus is less than 1000 or is null. Return name and bonus. **Output columns (in order):** name, bonus
Table:
employees| Column | Type |
|---|---|
| id | INT |
| name | TEXT |
Table:
bonuses| Column | Type |
|---|---|
| emp_id | INT |
| bonus | INT |
Examples
Input:
CREATE TABLE employees (id INT, name TEXT); CREATE TABLE bonuses (emp_id INT, bonus INT); INSERT INTO employees VALUES (1, 'Alice'), (2, 'Bob'), (3, 'Charlie'); INSERT INTO bonuses VALUES (1, 1500), (2, 500);Output:
Bob|500
Charlie|Explanation:
Alice has a bonus of 1500 (not less than 1000). Bob has a bonus of 500 (less than 1000). Charlie has no bonus record (null), so both Bob and Charlie are returned.
Input:
CREATE TABLE employees (id INT, name TEXT); CREATE TABLE bonuses (emp_id INT, bonus INT); INSERT INTO employees VALUES (1, 'David'), (2, 'Emma'), (3, 'Frank'), (4, 'Grace'); INSERT INTO bonuses VALUES (1, 2000), (2, 800), (3, 999), (4, 1000);Output:
Emma|800
Frank|999Explanation:
Emma has a bonus of 800 (less than 1000) and Frank has a bonus of 999 (less than 1000). David's bonus of 2000 and Grace's bonus of 1000 are not less than 1000, so they are excluded.
Input:
CREATE TABLE employees (id INT, name TEXT); CREATE TABLE bonuses (emp_id INT, bonus INT); INSERT INTO employees VALUES (1, 'John'), (2, 'Sarah'), (3, 'Mike'); INSERT INTO bonuses VALUES (2, 1200);Output:
John|
Mike|Explanation:
John and Mike have no bonus records (null bonus), so they qualify. Sarah has a bonus of 1200 which is not less than 1000, so she is excluded.
Constraints
- •
Use LEFT JOIN