Problem 4 Select all employee's name and bonus whose bonus is < 1000. Table:Employee | empld | name | supervisor| salary | | 3 | Dan | 1 | 2 | 3 | 1000 | | 2000 | | 4000 | | 4000 | | John | 3 | Brad I null | Thomas | 3 4 -----+ empld is the primary key column for this table. Table: Bonus || empld | bonus | | 2 | 500 I | 4 | 2000 | empld is the primary key column for this table. Example ouput | name | bonus || || John | null | | Dan | 500 I | Brad | null |
Problem 4 Select all employee's name and bonus whose bonus is < 1000. Table:Employee | empld | name | supervisor| salary | | 3 | Dan | 1 | 2 | 3 | 1000 | | 2000 | | 4000 | | 4000 | | John | 3 | Brad I null | Thomas | 3 4 -----+ empld is the primary key column for this table. Table: Bonus || empld | bonus | | 2 | 500 I | 4 | 2000 | empld is the primary key column for this table. Example ouput | name | bonus || || John | null | | Dan | 500 I | Brad | null |
Chapter6: Updating Data
Section: Chapter Questions
Problem 4SCG
Related questions
Question
![Problem 4
Select all employee's name and bonus whose bonus is < 1000.
Table:Employee
| empld | name
| supervisor| salary |
+-
| John
| 3
| Dan
| 3
| Brad
| null
| Thomas | 3
| 1000 |
| 2000 |
| 4000 |
| 4000 |
| 1
| 2
| 3
| 4
+---------+-
empld is the primary key column for this table.
Table: Bonus
| empld | bonus |
+-
| 500 I
| 2000 |
12
14
-+---------+
empld is the primary key column for this table.
Example ouput:
+----
| name | bonus |
+-----
------+
| John | null
| Dan
| 500 |
| Brad | null |
|
+.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffee8e972-a024-44e3-9edd-c47fc96d3820%2F029e8ff1-5739-47e1-b3ee-09b4810eb3d9%2Fwutgnh_processed.png&w=3840&q=75)
Transcribed Image Text:Problem 4
Select all employee's name and bonus whose bonus is < 1000.
Table:Employee
| empld | name
| supervisor| salary |
+-
| John
| 3
| Dan
| 3
| Brad
| null
| Thomas | 3
| 1000 |
| 2000 |
| 4000 |
| 4000 |
| 1
| 2
| 3
| 4
+---------+-
empld is the primary key column for this table.
Table: Bonus
| empld | bonus |
+-
| 500 I
| 2000 |
12
14
-+---------+
empld is the primary key column for this table.
Example ouput:
+----
| name | bonus |
+-----
------+
| John | null
| Dan
| 500 |
| Brad | null |
|
+.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage